eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 513: pay_element_type_extra_info petei,

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) || ''')
517: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_end_date) || ''')

Line 558: pay_element_type_extra_info petei,

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) || ''')
562: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_end_date) || ''')

Line 581: pay_element_type_extra_info petei

577: and ppe.effective_date between paf.effective_start_date and paf.effective_end_date
578: union
579: select distinct pee.assignment_id
580: from pay_element_entries_f pee,
581: pay_element_type_extra_info petei
582: where pee.effective_start_date between
583: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_period_start_date) || ''')
584: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_period_end_date) || ''')
585: and petei.element_type_id = pee.element_type_id

Line 652: pay_element_type_extra_info petei,

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
656: and peu.dated_table_id = pde.dated_table_id

Line 705: pay_element_type_extra_info petei,

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
709: and peu.dated_table_id = pde.dated_table_id

Line 726: pay_element_type_extra_info petei

722: and ppe.effective_date between paf.effective_start_date and paf.effective_end_date
723: union
724: select distinct pee.assignment_id
725: from pay_element_entries_f pee,
726: pay_element_type_extra_info petei
727: where pee.effective_start_date between cp_period_start_date and cp_period_end_date
728: and petei.element_type_id = pee.element_type_id
729: and petei.eei_information_category='PQP_UK_RATE_TYPE'
730: and petei.eei_information1='MX_IDWV'

Line 1323: pay_element_type_extra_info petei

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
1327: and peu.dated_table_id = pde.dated_table_id