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

Line 331: FROM per_all_assignments_f paa

327: ,c_person_id IN NUMBER
328: ,c_start_date IN DATE
329: ,c_end_date IN DATE) IS
330: SELECT 1
331: FROM per_all_assignments_f paa
332: ,per_assignment_status_types past
333: ,per_all_people_f pap
334: ,per_org_structure_versions posv
335: ,per_absence_attendances pab

Line 378: FROM per_all_assignments_f paa

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

Line 756: ,per_all_assignments_f paa

752: paa.assignment_id assignment_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 = 'WAZO'
759: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
760: AND paat.business_group_id = pab.business_group_id

Line 789: ,per_all_assignments_f paa

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

Line 840: ,per_all_assignments_f paa

836: SELECT DISTINCT
837: paa.assignment_id assignment_id
838: FROM per_absence_attendance_types paat
839: ,per_absence_attendances pab
840: ,per_all_assignments_f paa
841: ,per_all_people_f pap
842: ,pay_payroll_actions ppa
843: ,per_org_structure_versions posv
844: WHERE posv.organization_structure_id = p_org_struct_id

Line 891: ,per_all_assignments_f paa

887: SELECT DISTINCT
888: paa.assignment_id assignment_id
889: FROM pay_action_information pai
890: ,pay_payroll_actions ppa
891: ,per_all_assignments_f paa
892: ,per_all_people_f pap
893: WHERE pai.action_context_type = 'AAP'
894: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'
895: AND pai.action_information4 = 'WAZO'

Line 933: ,per_all_assignments_f paa

929: paa.assignment_id assignment_id
930: FROM pay_action_information pai
931: ,pay_payroll_actions ppa
932: ,per_org_structure_versions posv
933: ,per_all_assignments_f paa
934: ,per_all_people_f pap
935: WHERE posv.organization_structure_id = p_org_struct_id
936: AND posv.date_from <= p_end_date
937: AND nvl (posv.date_to

Line 992: ,per_all_assignments_f paa

988: ,p_type IN VARCHAR2) IS
989: SELECT DISTINCT
990: paa.assignment_id assignment_id
991: FROM pay_action_information pai
992: ,per_all_assignments_f paa
993: ,per_all_people_f pap
994: ,pay_payroll_actions ppa
995: ,per_org_structure_versions posv
996: WHERE posv.organization_structure_id = p_org_struct_id

Line 1169: FROM per_all_assignments_f pas

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

Line 1187: FROM per_all_assignments_f pas

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

Line 1215: ,per_all_assignments_f pas

1211: ,to_char (pab.date_start,'YYYYMMDD') wazo_st_dt
1212: FROM per_absence_attendance_types paat
1213: ,per_absence_attendances pab
1214: ,pay_assignment_actions paa
1215: ,per_all_assignments_f pas
1216: WHERE paat.absence_category = 'WAZO'
1217: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1218: AND paat.business_group_id = pab.business_group_id
1219: AND pab.date_start BETWEEN p_start_date

Line 1279: FROM per_all_assignments_f pas

1275: ,hoi.org_information6 contact_per_or_dept
1276: ,hoi.org_information7 est_name
1277: ,hoi.org_information8 gender_contact
1278: ,hoi.org_information9 ph_no_contact
1279: FROM per_all_assignments_f pas
1280: ,hr_organization_units hou
1281: ,hr_organization_information hoi
1282: WHERE pas.assignment_id = p_assignment_id
1283: AND p_start_date BETWEEN pas.effective_start_date

Line 1295: FROM per_all_assignments_f pas

1291: CURSOR csr_get_employer_bank_info (p_assignment_id IN NUMBER
1292: , p_start_date IN DATE) IS
1293: SELECT upper(pea.segment2) acc_no
1294: ,pea.segment10 iban
1295: FROM per_all_assignments_f pas
1296: ,pay_payrolls_f pp
1297: ,pay_org_payment_methods_f popm
1298: ,pay_external_accounts pea
1299: WHERE pas.assignment_id = p_assignment_id

Line 1324: ,per_all_assignments_f pas

1320: ,pap.person_id person_id
1321: ,pap.business_group_id bg_id
1322: ,pas.establishment_id establishment_id
1323: FROM per_all_people_f pap
1324: ,per_all_assignments_f pas
1325: WHERE pas.assignment_id = p_assignment_id
1326: AND p_start_date BETWEEN pas.effective_start_date
1327: AND pas.effective_end_date
1328: AND pap.person_id = pas.person_id

Line 1352: FROM per_all_assignments_f pas

1348: , p_start_date IN DATE) IS
1349: SELECT decode (hsck.segment4, 'Y', '1', 'N', '2') wage_tax_discount
1350: ,hsck.segment11 wage_tax_table
1351: ,pas.assignment_sequence asg_seq
1352: FROM per_all_assignments_f pas
1353: ,hr_soft_coding_keyflex hsck
1354: WHERE pas.assignment_id = p_assignment_id
1355: AND p_start_date BETWEEN pas.effective_start_date
1356: AND pas.effective_end_date

Line 1377: FROM per_all_assignments_f pas

1373: CURSOR csr_get_phone_no(p_assignment_id IN NUMBER
1374: , p_start_date IN DATE
1375: , p_type IN VARCHAR2) IS
1376: SELECT pp.phone_number phone_no
1377: FROM per_all_assignments_f pas
1378: ,per_phones pp
1379: WHERE pas.assignment_id = p_assignment_id
1380: AND p_start_date BETWEEN pas.effective_start_date
1381: AND pas.effective_end_date

Line 1408: FROM per_all_assignments_f pas

1404: ,pad.add_information13 info13
1405: ,pad.add_information14 info14
1406: ,pad.add_information15 info15
1407: ,pad.add_information16 info16
1408: FROM per_all_assignments_f pas
1409: ,per_addresses pad
1410: WHERE pas.assignment_id = p_assignment_id
1411: AND p_start_date BETWEEN pas.effective_start_date
1412: AND pas.effective_end_date

Line 1448: FROM per_all_assignments_f pas

1444: ,pad.add_information13 info13
1445: ,pad.add_information14 info14
1446: ,pad.add_information15 info15
1447: ,pad.add_information16 info16
1448: FROM per_all_assignments_f pas
1449: ,per_addresses pad
1450: WHERE pas.assignment_id = p_assignment_id
1451: AND p_start_date BETWEEN pas.effective_start_date
1452: AND pas.effective_end_date

Line 1465: FROM per_all_assignments_f pas

1461: SELECT pei_information21 contact_name
1462: ,pei_information22 est_name
1463: ,pei_information23 gender
1464: ,pei_information24 contact_ph_no
1465: FROM per_all_assignments_f pas
1466: ,per_people_extra_info pei
1467: WHERE pas.assignment_id = p_assignment_id
1468: AND p_start_date BETWEEN pas.effective_start_date
1469: AND pas.effective_end_date

Line 1494: FROM per_all_assignments_f pas

1490: SELECT to_char(min (pas.effective_start_date),'YYYYMMDD') ass_start_date
1491: ,to_char(decode (max (pas.effective_end_date)
1492: ,hr_general.end_of_time
1493: ,to_date(NULL),max (pas.effective_end_date)),'YYYYMMDD') ass_end_date
1494: FROM per_all_assignments_f pas
1495: WHERE pas.assignment_id = p_assignment_id;
1496: /**************************************************************************/
1497: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS
1498: SELECT paei.aei_information1 numiv_override