DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on PER_ALL_ASSIGNMENTS_F

Line 606: from per_all_assignments_f asg,

602: cp_effective_date date,
603: cp_orig_effective_date date
604: ) is
605: select pay.period_type
606: from per_all_assignments_f asg,
607: pay_payrolls_f pay,
608: per_all_assignments_f asg2,
609: pay_payrolls_f pay2
610: where asg.person_id = cp_person_id

Line 608: per_all_assignments_f asg2,

604: ) is
605: select pay.period_type
606: from per_all_assignments_f asg,
607: pay_payrolls_f pay,
608: per_all_assignments_f asg2,
609: pay_payrolls_f pay2
610: where asg.person_id = cp_person_id
611: and asg.assignment_type <> 'C'
612: and asg.business_group_id = cp_business_group_id

Line 737: from per_all_assignments_f asg,

733: asg.payroll_id,
734: pee.element_entry_id,
735: pee.assignment_id,
736: pee.effective_end_date
737: from per_all_assignments_f asg,
738: pay_element_links_f elk,
739: pay_element_entries_f pee,
740: pay_element_entry_values_f eev
741: where eev.element_entry_value_id = p_element_entry_value_id