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_NL_DSRR_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 327: FROM per_all_assignments_f paa

323: ,c_person_id IN NUMBER
324: ,c_start_date IN DATE
325: ,c_end_date IN DATE) IS
326: SELECT 1
327: FROM per_all_assignments_f paa
328: ,per_assignment_status_types past
329: ,per_all_people_f pap
330: ,per_org_structure_versions posv
331: ,per_absence_attendances pab

Line 375: FROM per_all_assignments_f paa

371: ,c_person_id IN NUMBER
372: ,c_start_date IN DATE
373: ,c_end_date IN DATE) IS
374: SELECT 1
375: FROM per_all_assignments_f paa
376: ,per_all_people_f pap
377: ,per_org_structure_versions posv
378: ,per_absence_attendances pab
379: ,per_absence_attendance_types paat

Line 756: , per_all_assignments_f paa

752: , pab.absence_attendance_id abs_att_id
753: FROM per_absence_attendance_types paat
754: , per_absence_attendances pab
755: , pay_payroll_actions ppa
756: , per_all_assignments_f paa
757: , per_all_people_f pap
758: WHERE paat.absence_category = 'S'
759: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
760: AND paat.business_group_id = pab.business_group_id

Line 791: , per_all_assignments_f paa

787: FROM per_absence_attendance_types paat
788: , per_absence_attendances pab
789: , pay_payroll_actions ppa
790: , per_org_structure_versions posv
791: , per_all_assignments_f paa
792: , per_all_people_f pap
793: WHERE posv.organization_structure_id = p_org_struct_id
794: AND posv.date_from <= p_end_date
795: AND nvl (posv.date_to, hr_general.end_of_time) >= p_start_date

Line 844: , per_all_assignments_f paa

840: paa.assignment_id assignment_id
841: , pab.absence_attendance_id abs_att_id
842: FROM per_absence_attendance_types paat
843: , per_absence_attendances pab
844: , per_all_assignments_f paa
845: , per_all_people_f pap
846: , pay_payroll_actions ppa
847: , per_org_structure_versions posv
848: WHERE posv.organization_structure_id = p_org_struct_id

Line 896: , per_all_assignments_f paa

892: SELECT DISTINCT
893: paa.assignment_id assignment_id
894: FROM pay_action_information pai
895: , pay_payroll_actions ppa
896: , per_all_assignments_f paa
897: , per_all_people_f pap
898: WHERE pai.action_context_type = 'AAP'
899: AND pai.action_information_category = 'NL_DSRR_ABS_INFO'
900: AND pai.action_information4 = 'SRR'

Line 938: , per_all_assignments_f paa

934: paa.assignment_id assignment_id
935: FROM pay_action_information pai
936: , pay_payroll_actions ppa
937: , per_org_structure_versions posv
938: , per_all_assignments_f paa
939: , per_all_people_f pap
940: WHERE posv.organization_structure_id = p_org_struct_id
941: AND posv.date_from <= p_end_date
942: AND nvl (posv.date_to

Line 997: , per_all_assignments_f paa

993: ,p_type IN VARCHAR2) IS
994: SELECT DISTINCT
995: paa.assignment_id assignment_id
996: FROM pay_action_information pai
997: , per_all_assignments_f paa
998: , per_all_people_f pap
999: , pay_payroll_actions ppa
1000: , per_org_structure_versions posv
1001: WHERE posv.organization_structure_id = p_org_struct_id

Line 1171: FROM per_all_assignments_f pas

1167: ,p_abs_start_date IN DATE) IS
1168: SELECT hou.organization_id org_id
1169: ,hou.name org_name
1170: ,hoi.org_information4 tax_reg
1171: FROM per_all_assignments_f pas
1172: ,hr_organization_units hou
1173: ,hr_organization_information hoi
1174: ,per_org_structure_versions posv
1175: WHERE posv.organization_structure_id = p_org_struct_id

Line 1189: FROM per_all_assignments_f pas

1185: CURSOR csr_get_leg_info(p_assignment_id IN NUMBER) IS
1186: SELECT hou.organization_id org_id
1187: ,hou.name org_name
1188: ,hoi.org_information1 tax_reg
1189: FROM per_all_assignments_f pas
1190: ,hr_organization_units hou
1191: ,hr_organization_information hoi
1192: WHERE pas.assignment_id = p_assignment_id
1193: AND hou.organization_id = pas.establishment_id

Line 1225: ,per_all_assignments_f pas

1221: ,pab.abs_information13 daily_si
1222: FROM per_absence_attendance_types paat
1223: ,per_absence_attendances pab
1224: ,pay_assignment_actions paa
1225: ,per_all_assignments_f pas
1226: WHERE paat.absence_category = 'S'
1227: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1228: AND paat.business_group_id = pab.business_group_id
1229: AND (pab.date_end + 1) BETWEEN p_start_date

Line 1265: FROM per_all_assignments_f pas

1261: ,hoi.org_information6 contact_per_or_dept
1262: ,hoi.org_information7 est_name
1263: ,hoi.org_information8 gender_contact
1264: ,hoi.org_information9 ph_no_contact
1265: FROM per_all_assignments_f pas
1266: ,hr_organization_units hou
1267: ,hr_organization_information hoi
1268: WHERE pas.assignment_id = p_assignment_id
1269: AND p_start_date BETWEEN pas.effective_start_date

Line 1294: ,per_all_assignments_f pas

1290: ,pap.business_group_id bg_id
1291: ,pas.establishment_id establishment_id
1292: ,pas.assignment_sequence asg_seq
1293: FROM per_all_people_f pap
1294: ,per_all_assignments_f pas
1295: WHERE pas.assignment_id = p_assignment_id
1296: AND p_start_date BETWEEN pas.effective_start_date
1297: AND pas.effective_end_date
1298: AND pap.person_id = pas.person_id

Line 1310: FROM per_all_assignments_f pas

1306: SELECT pei_information21 contact_name
1307: ,pei_information22 est_name
1308: ,pei_information23 gender
1309: ,pei_information24 contact_ph_no
1310: FROM per_all_assignments_f pas
1311: ,per_people_extra_info pei
1312: WHERE pas.assignment_id = p_assignment_id
1313: AND p_start_date BETWEEN pas.effective_start_date
1314: AND pas.effective_end_date