DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on PER_ALL_ASSIGNMENTS_F

Line 654: from per_all_assignments_f asg,

650: cp_effective_date date,
651: cp_orig_effective_date date
652: ) is
653: select pay.period_type
654: from per_all_assignments_f asg,
655: pay_payrolls_f pay,
656: per_all_assignments_f asg2,
657: pay_payrolls_f pay2
658: where asg.person_id = cp_person_id

Line 656: per_all_assignments_f asg2,

652: ) is
653: select pay.period_type
654: from per_all_assignments_f asg,
655: pay_payrolls_f pay,
656: per_all_assignments_f asg2,
657: pay_payrolls_f pay2
658: where asg.person_id = cp_person_id
659: and asg.assignment_type <> 'C'
660: and asg.business_group_id = cp_business_group_id

Line 785: from per_all_assignments_f asg,

781: asg.payroll_id,
782: pee.element_entry_id,
783: pee.assignment_id,
784: pee.effective_end_date
785: from per_all_assignments_f asg,
786: pay_element_links_f elk,
787: pay_element_entries_f pee,
788: pay_element_entry_values_f eev
789: where eev.element_entry_value_id = p_element_entry_value_id