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

Line 359: FROM per_all_assignments_f pas

355: ,hr_general.end_of_time);
356: /**************************************************************************/
357: CURSOR cur_get_person_id(c_assignment_id IN NUMBER) IS
358: SELECT pas.person_id
359: FROM per_all_assignments_f pas
360: WHERE pas.assignment_id = c_assignment_id;
361: /**************************************************************************/
362:
363: l_tml_info cur_get_tml_info%ROWTYPE;

Line 461: FROM per_all_assignments_f paa

457: ,c_person_id IN NUMBER
458: ,c_start_date IN DATE
459: ,c_end_date IN DATE) IS
460: SELECT 1
461: FROM per_all_assignments_f paa
462: ,per_assignment_status_types past
463: ,per_all_people_f pap
464: ,per_org_structure_versions posv
465: ,per_absence_attendances pab

Line 509: FROM per_all_assignments_f paa

505: ,c_person_id IN NUMBER
506: ,c_start_date IN DATE
507: ,c_end_date IN DATE) IS
508: SELECT 1
509: FROM per_all_assignments_f paa
510: ,per_all_people_f pap
511: ,per_org_structure_versions posv
512: ,per_absence_attendances pab
513: ,per_absence_attendance_types paat

Line 888: ,per_all_assignments_f paa

884: paa.assignment_id assignment_id
885: FROM per_absence_attendance_types paat
886: ,per_absence_attendances pab
887: ,pay_payroll_actions ppa
888: ,per_all_assignments_f paa
889: ,per_all_people_f pap
890: WHERE paat.absence_category = 'S'
891: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
892: AND paat.business_group_id = pab.business_group_id

Line 922: ,per_all_assignments_f paa

918: FROM per_absence_attendance_types paat
919: ,per_absence_attendances pab
920: ,pay_payroll_actions ppa
921: ,per_org_structure_versions posv
922: ,per_all_assignments_f paa
923: ,per_all_people_f pap
924: WHERE posv.organization_structure_id = p_org_struct_id
925: AND posv.date_from <= p_end_date
926: AND nvl (posv.date_to,hr_general.end_of_time) >= p_start_date

Line 974: ,per_all_assignments_f paa

970: SELECT DISTINCT
971: paa.assignment_id assignment_id
972: FROM per_absence_attendance_types paat
973: ,per_absence_attendances pab
974: ,per_all_assignments_f paa
975: ,per_all_people_f pap
976: ,pay_payroll_actions ppa
977: ,per_org_structure_versions posv
978: WHERE posv.organization_structure_id = p_org_struct_id

Line 1026: ,per_all_assignments_f paa

1022: SELECT DISTINCT
1023: paa.assignment_id assignment_id
1024: FROM pay_action_information pai
1025: ,pay_payroll_actions ppa
1026: ,per_all_assignments_f paa
1027: ,per_all_people_f pap
1028: WHERE pai.action_context_type = 'AAP'
1029: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1030: AND pai.action_information4 = 'SR'

Line 1068: ,per_all_assignments_f paa

1064: paa.assignment_id assignment_id
1065: FROM pay_action_information pai
1066: ,pay_payroll_actions ppa
1067: ,per_org_structure_versions posv
1068: ,per_all_assignments_f paa
1069: ,per_all_people_f pap
1070: WHERE posv.organization_structure_id = p_org_struct_id
1071: AND posv.date_from <= p_end_date
1072: AND nvl (posv.date_to

Line 1127: ,per_all_assignments_f paa

1123: ,p_type IN VARCHAR2) IS
1124: SELECT DISTINCT
1125: paa.assignment_id assignment_id
1126: FROM pay_action_information pai
1127: ,per_all_assignments_f paa
1128: ,per_all_people_f pap
1129: ,pay_payroll_actions ppa
1130: ,per_org_structure_versions posv
1131: WHERE posv.organization_structure_id = p_org_struct_id

Line 1303: FROM per_all_assignments_f pas

1299: , p_abs_start_date IN DATE) IS
1300: SELECT hou.organization_id org_id
1301: ,hou.name org_name
1302: ,hoi.org_information4 tax_reg
1303: FROM per_all_assignments_f pas
1304: ,hr_organization_units hou
1305: ,hr_organization_information hoi
1306: ,per_org_structure_versions posv
1307: WHERE posv.organization_structure_id = p_org_struct_id

Line 1321: FROM per_all_assignments_f pas

1317: CURSOR csr_get_leg_info(p_assignment_id IN NUMBER) IS
1318: SELECT hou.organization_id org_id
1319: ,hou.name org_name
1320: ,hoi.org_information1 tax_reg
1321: FROM per_all_assignments_f pas
1322: ,hr_organization_units hou
1323: ,hr_organization_information hoi
1324: WHERE pas.assignment_id = p_assignment_id
1325: AND hou.organization_id = pas.establishment_id

Line 1368: ,per_all_assignments_f pas

1364: ,pab.abs_information26 temp_cont
1365: FROM per_absence_attendance_types paat
1366: ,per_absence_attendances pab
1367: ,pay_assignment_actions paa
1368: ,per_all_assignments_f pas
1369: WHERE paat.absence_category = 'S'
1370: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1371: AND paat.business_group_id = pab.business_group_id
1372: AND pab.date_start BETWEEN p_start_date

Line 1434: FROM per_all_assignments_f pas

1430: ,hoi.org_information6 contact_per_or_dept
1431: ,hoi.org_information7 est_name
1432: ,hoi.org_information8 gender_contact
1433: ,hoi.org_information9 ph_no_contact
1434: FROM per_all_assignments_f pas
1435: ,hr_organization_units hou
1436: ,hr_organization_information hoi
1437: WHERE pas.assignment_id = p_assignment_id
1438: AND p_start_date BETWEEN pas.effective_start_date

Line 1450: FROM per_all_assignments_f pas

1446: CURSOR csr_get_employer_bank_info (p_assignment_id IN NUMBER
1447: , p_start_date IN DATE) IS
1448: SELECT upper(pea.segment2) acc_no
1449: ,pea.segment10 iban
1450: FROM per_all_assignments_f pas
1451: ,pay_payrolls_f pp
1452: ,pay_org_payment_methods_f popm
1453: ,pay_external_accounts pea
1454: WHERE pas.assignment_id = p_assignment_id

Line 1479: ,per_all_assignments_f pas

1475: ,pap.person_id person_id
1476: ,pap.business_group_id bg_id
1477: ,pas.establishment_id establishment_id
1478: FROM per_all_people_f pap
1479: ,per_all_assignments_f pas
1480: WHERE pas.assignment_id = p_assignment_id
1481: AND p_start_date BETWEEN pas.effective_start_date
1482: AND pas.effective_end_date
1483: AND pap.person_id = pas.person_id

Line 1491: FROM per_all_assignments_f pas

1487: /* Job details */
1488: CURSOR csr_get_job(p_assignment_id IN NUMBER
1489: , p_start_date IN DATE ) IS
1490: SELECT pj.name
1491: FROM per_all_assignments_f pas
1492: ,per_jobs pj
1493: WHERE pas.assignment_id = p_assignment_id
1494: AND p_start_date BETWEEN pas.effective_start_date
1495: AND pas.effective_end_date

Line 1524: FROM per_all_assignments_f pas

1520: ,decode(pca.cag_information5, 'Y', '1', 'N', '2') temp_worker
1521: ,decode(pca.cag_information6, 'Y', '1', 'N', '2') temp_to_contr
1522: ,decode(pca.cag_information7, 'Y', '1', 'N', '2') termination
1523: ,decode(pca.cag_information8, 'Y', '1', 'N', '2') appr_temp_worker
1524: FROM per_all_assignments_f pas
1525: ,per_collective_agreements pca
1526: WHERE pas.assignment_id = p_assignment_id
1527: AND p_start_date BETWEEN pas.effective_start_date
1528: AND pas.effective_end_date

Line 1540: FROM per_all_assignments_f pas

1536: ,hsck.segment11 wage_tax_table
1537: ,pas.assignment_sequence asg_seq
1538: ,pas.employment_category employment_cat
1539: ,pas.employee_category employee_cat
1540: FROM per_all_assignments_f pas
1541: ,hr_soft_coding_keyflex hsck
1542: WHERE pas.assignment_id = p_assignment_id
1543: AND p_start_date BETWEEN pas.effective_start_date
1544: AND pas.effective_end_date

Line 1576: FROM per_all_assignments_f pas

1572: CURSOR csr_get_phone_no(p_assignment_id IN NUMBER
1573: , p_start_date IN DATE
1574: , p_type IN VARCHAR2) IS
1575: SELECT pp.phone_number phone_no
1576: FROM per_all_assignments_f pas
1577: ,per_phones pp
1578: WHERE pas.assignment_id = p_assignment_id
1579: AND p_start_date BETWEEN pas.effective_start_date
1580: AND pas.effective_end_date

Line 1607: FROM per_all_assignments_f pas

1603: ,pad.add_information13 info13
1604: ,pad.add_information14 info14
1605: ,pad.add_information15 info15
1606: ,pad.add_information16 info16
1607: FROM per_all_assignments_f pas
1608: ,per_addresses pad
1609: WHERE pas.assignment_id = p_assignment_id
1610: AND p_start_date BETWEEN pas.effective_start_date
1611: AND pas.effective_end_date

Line 1647: FROM per_all_assignments_f pas

1643: ,pad.add_information13 info13
1644: ,pad.add_information14 info14
1645: ,pad.add_information15 info15
1646: ,pad.add_information16 info16
1647: FROM per_all_assignments_f pas
1648: ,per_addresses pad
1649: WHERE pas.assignment_id = p_assignment_id
1650: AND p_start_date BETWEEN pas.effective_start_date
1651: AND pas.effective_end_date

Line 1665: FROM per_all_assignments_f pas

1661: ,pei_information22 est_name
1662: ,pei_information23 gender
1663: ,pei_information24 contact_ph_no
1664: ,pei_information3 l29bzw
1665: FROM per_all_assignments_f pas
1666: ,per_people_extra_info pei
1667: WHERE pas.assignment_id = p_assignment_id
1668: AND p_start_date BETWEEN pas.effective_start_date
1669: AND pas.effective_end_date

Line 1730: FROM per_all_assignments_f pas

1726: SELECT to_char(min (pas.effective_start_date),'YYYYMMDD') ass_start_date
1727: ,to_char(decode (max (pas.effective_end_date)
1728: ,hr_general.end_of_time
1729: ,to_date(NULL),max (pas.effective_end_date)),'YYYYMMDD') ass_end_date
1730: FROM per_all_assignments_f pas
1731: WHERE pas.assignment_id = p_assignment_id;
1732: /**************************************************************************/
1733: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS
1734: SELECT paei.aei_information1 numiv_override