DBA Data[Home] [Help]

APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_ELEMENT_TYPES_F

Line 512: pay_element_types_f pet,

508: from pay_process_events ppe,
509: pay_datetracked_events pde,
510: pay_event_updates peu,
511: pay_element_entries_f pee,
512: pay_element_types_f pet,
513: pay_element_type_extra_info petei,
514: per_all_assignments_f paf
515: where ppe.creation_date between
516: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_start_date) || ''')

Line 557: pay_element_types_f pet,

553: from pay_process_events ppe,
554: pay_datetracked_events pde,
555: pay_event_updates peu,
556: pay_element_entries_f pee,
557: pay_element_types_f pet,
558: pay_element_type_extra_info petei,
559: per_all_assignments_f paf
560: where ppe.creation_date between
561: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_start_date) || ''')

Line 651: pay_element_types_f pet,

647: from pay_process_events ppe,
648: pay_datetracked_events pde,
649: pay_event_updates peu,
650: pay_element_entries_f pee,
651: pay_element_types_f pet,
652: pay_element_type_extra_info petei,
653: per_all_assignments_f paf
654: where ppe.creation_date between cp_start_date and cp_end_date
655: and peu.event_update_id =ppe.event_update_id

Line 704: pay_element_types_f pet,

700: from pay_process_events ppe,
701: pay_datetracked_events pde,
702: pay_event_updates peu,
703: pay_element_entries_f pee,
704: pay_element_types_f pet,
705: pay_element_type_extra_info petei,
706: per_all_assignments_f paf
707: where ppe.creation_date between cp_start_date and cp_end_date
708: and peu.event_update_id =ppe.event_update_id

Line 1322: pay_element_types_f pet,

1318: from pay_process_events ppe,
1319: pay_datetracked_events pde,
1320: pay_event_updates peu,
1321: pay_element_entries_f pee,
1322: pay_element_types_f pet,
1323: pay_element_type_extra_info petei
1324: where ppe.assignment_id = cp_assignment_id
1325: and ppe.creation_date between cp_start_date and cp_end_date
1326: and peu.event_update_id =ppe.event_update_id