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.PER_MX_SSAFFL_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 636: per_all_assignments_f paf

632: -- ,per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)
633: from pay_process_events ppe,
634: pay_event_updates peu,
635: pay_datetracked_events pde,
636: per_all_assignments_f paf
637: where ppe.creation_date between cp_start_date and cp_end_date
638: and peu.event_update_id = ppe.event_update_id
639: and ppe.business_group_id = cp_business_group_id
640: and pde.dated_table_id = peu.dated_table_id

Line 825: from per_all_assignments_f paf

821: ,cp_gre_id in number
822: ,cp_effective_date in date )
823: IS
824: select 'Y'
825: from per_all_assignments_f paf
826: where paf.assignment_id <> cp_skip_assignment_id
827: and paf.person_id = cp_person_id
828: and cp_effective_date between paf.effective_start_date and paf.effective_end_date
829: and per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,cp_effective_date)

Line 915: from per_all_assignments_f paf,

911: ,ppf.last_name paternal_last_name
912: ,ppf.per_information1 maternal_last_name
913: ,ppf.first_name || ' ' ||ppf.middle_names name
914: ,ppf.employee_number worker_id
915: from per_all_assignments_f paf,
916: per_all_people_f ppf
917: where paf.assignment_id = cp_assignment_id
918: and paf.person_id = ppf.person_id
919: and cp_effective_date between paf.effective_start_date and paf.effective_end_date

Line 953: per_all_assignments_f paf

949: ,cp_effective_date in date )
950: is
951: select pds_information1, actual_termination_date
952: from per_periods_of_service ppos,
953: per_all_assignments_f paf
954: where paf.assignment_id = cp_assignment_id
955: and paf.person_id = ppos.person_id
956: and cp_effective_date between paf.effective_start_date and paf.effective_end_date
957: and pds_information_category='MX' ;

Line 1167: from per_all_assignments_f paf,

1163: ,puc.user_column_name work_schedule
1164: ,per_information4 med_center
1165: ,employee_number worker_id
1166: ,national_identifier CURP
1167: from per_all_assignments_f paf,
1168: per_all_people_f ppf,
1169: hr_soft_coding_keyflex hsc,
1170: pay_user_columns puc
1171: where paf.assignment_id = cp_assignment_id

Line 1594: per_all_assignments_f paf

1590: cp_action_info_category varchar2 )
1591: is
1592: select 'Y'
1593: from pay_action_information pai,
1594: per_all_assignments_f paf
1595: where pai.action_context_type ='AAP'
1596: and pai.action_information_category = cp_action_info_category
1597: and pai.tax_unit_id = cp_gre_id
1598: and pai.assignment_id = paf.assignment_id

Line 1612: from per_all_assignments_f paf

1608: paf.assignment_number,
1609: paf.location_id,
1610: paf.soft_coding_keyflex_id,
1611: paf.business_group_id
1612: from per_all_assignments_f paf
1613: where paf.assignment_id = cp_assignment_id
1614: and cp_effective_date between paf.effective_start_date
1615: and paf.effective_end_date ;
1616:

Line 1821: from per_all_assignments_f paf

1817: assignment_number,
1818: location_id,
1819: soft_coding_keyflex_id,
1820: business_group_id
1821: from per_all_assignments_f paf
1822: where paf.assignment_id = cp_assignment_id
1823: and cp_effective_date between paf.effective_start_date
1824: and paf.effective_end_date ;
1825:

Line 1835: per_all_assignments_f paf

1831: cp_action_info_category varchar2 )
1832: is
1833: select 'Y'
1834: from pay_action_information pai,
1835: per_all_assignments_f paf
1836: where pai.action_context_type ='AAP'
1837: and pai.action_information_category = cp_action_info_category
1838: and pai.tax_unit_id = cp_gre_id
1839: and pai.assignment_id = paf.assignment_id

Line 2149: from per_all_assignments_f paf

2145: assignment_number,
2146: location_id,
2147: soft_coding_keyflex_id,
2148: business_group_id
2149: from per_all_assignments_f paf
2150: where paf.assignment_id = cp_assignment_id
2151: and cp_effective_date between paf.effective_start_date
2152: and paf.effective_end_date ;
2153:

Line 2162: per_all_assignments_f paf

2158: cp_action_info_category varchar2 )
2159: is
2160: select 'Y'
2161: from pay_action_information pai,
2162: per_all_assignments_f paf
2163: where pai.action_context_type ='AAP'
2164: and pai.action_information_category = cp_action_info_category
2165: and pai.tax_unit_id = cp_gre_id
2166: and pai.assignment_id = paf.assignment_id

Line 2454: from per_all_assignments_f paf,

2450: is
2451: select paf.person_id,paf.assignment_number,paf.location_id,
2452: paf.soft_coding_keyflex_id, pas.per_system_status,
2453: paf.business_group_id
2454: from per_all_assignments_f paf,
2455: per_assignment_status_types pas
2456: where paf.assignment_id = cp_assignment_id
2457: and pas.assignment_status_type_id = paf.assignment_status_type_id
2458: and cp_effective_date between paf.effective_start_date