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_IN_EOY_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 581: ,per_all_people_f pep

577: ,pep.sex gender
578: ,pep.per_information7 residential_status
579: FROM per_all_assignments_f asg
580: ,hr_soft_coding_keyflex scl
581: ,per_all_people_f pep
582: WHERE asg.assignment_id = p_assignment_id
583: AND pep.person_id = asg.person_id
584: AND pep.business_group_id = g_bg_id
585: AND asg.business_group_id = g_bg_id

Line 613: FROM per_all_people_f pep

609: SELECT DECODE(pea.title,NULL,hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
610: ,SUBSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
611: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1))father
612: ,pea.title title
613: FROM per_all_people_f pep
614: ,per_all_people_f pea
615: ,per_contact_relationships con
616: WHERE pep.person_id = p_person_id
617: AND pea.person_id =con.contact_person_id

Line 614: ,per_all_people_f pea

610: ,SUBSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
611: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1))father
612: ,pea.title title
613: FROM per_all_people_f pep
614: ,per_all_people_f pea
615: ,per_contact_relationships con
616: WHERE pep.person_id = p_person_id
617: AND pea.person_id =con.contact_person_id
618: AND pep.business_group_id = g_bg_id

Line 646: l_person_id per_all_people_f.person_id%TYPE;

642: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'))
643: ORDER BY phone_type ASC;
644:
645: l_emp_no per_all_assignments_f.assignment_number%TYPE;
646: l_person_id per_all_people_f.person_id%TYPE;
647: l_dob VARCHAR2(30);
648: l_pan per_all_people_f.per_information4%TYPE;
649: l_residential_status per_all_people_f.per_information7%TYPE;
650: l_name per_all_people_f.full_name%TYPE;

Line 648: l_pan per_all_people_f.per_information4%TYPE;

644:
645: l_emp_no per_all_assignments_f.assignment_number%TYPE;
646: l_person_id per_all_people_f.person_id%TYPE;
647: l_dob VARCHAR2(30);
648: l_pan per_all_people_f.per_information4%TYPE;
649: l_residential_status per_all_people_f.per_information7%TYPE;
650: l_name per_all_people_f.full_name%TYPE;
651: l_emp_title per_all_people_f.title%TYPE;
652: l_emp_fath_title per_all_people_f.title%TYPE;

Line 649: l_residential_status per_all_people_f.per_information7%TYPE;

645: l_emp_no per_all_assignments_f.assignment_number%TYPE;
646: l_person_id per_all_people_f.person_id%TYPE;
647: l_dob VARCHAR2(30);
648: l_pan per_all_people_f.per_information4%TYPE;
649: l_residential_status per_all_people_f.per_information7%TYPE;
650: l_name per_all_people_f.full_name%TYPE;
651: l_emp_title per_all_people_f.title%TYPE;
652: l_emp_fath_title per_all_people_f.title%TYPE;
653: l_father_name per_all_people_f.full_name%TYPE;

Line 650: l_name per_all_people_f.full_name%TYPE;

646: l_person_id per_all_people_f.person_id%TYPE;
647: l_dob VARCHAR2(30);
648: l_pan per_all_people_f.per_information4%TYPE;
649: l_residential_status per_all_people_f.per_information7%TYPE;
650: l_name per_all_people_f.full_name%TYPE;
651: l_emp_title per_all_people_f.title%TYPE;
652: l_emp_fath_title per_all_people_f.title%TYPE;
653: l_father_name per_all_people_f.full_name%TYPE;
654: l_gender per_all_people_f.sex%TYPE;

Line 651: l_emp_title per_all_people_f.title%TYPE;

647: l_dob VARCHAR2(30);
648: l_pan per_all_people_f.per_information4%TYPE;
649: l_residential_status per_all_people_f.per_information7%TYPE;
650: l_name per_all_people_f.full_name%TYPE;
651: l_emp_title per_all_people_f.title%TYPE;
652: l_emp_fath_title per_all_people_f.title%TYPE;
653: l_father_name per_all_people_f.full_name%TYPE;
654: l_gender per_all_people_f.sex%TYPE;
655: l_pos per_all_positions.name%TYPE;

Line 652: l_emp_fath_title per_all_people_f.title%TYPE;

648: l_pan per_all_people_f.per_information4%TYPE;
649: l_residential_status per_all_people_f.per_information7%TYPE;
650: l_name per_all_people_f.full_name%TYPE;
651: l_emp_title per_all_people_f.title%TYPE;
652: l_emp_fath_title per_all_people_f.title%TYPE;
653: l_father_name per_all_people_f.full_name%TYPE;
654: l_gender per_all_people_f.sex%TYPE;
655: l_pos per_all_positions.name%TYPE;
656: l_employee_address per_addresses.address_id%TYPE;

Line 653: l_father_name per_all_people_f.full_name%TYPE;

649: l_residential_status per_all_people_f.per_information7%TYPE;
650: l_name per_all_people_f.full_name%TYPE;
651: l_emp_title per_all_people_f.title%TYPE;
652: l_emp_fath_title per_all_people_f.title%TYPE;
653: l_father_name per_all_people_f.full_name%TYPE;
654: l_gender per_all_people_f.sex%TYPE;
655: l_pos per_all_positions.name%TYPE;
656: l_employee_address per_addresses.address_id%TYPE;
657: l_employee_address_type per_addresses.address_type%TYPE;

Line 654: l_gender per_all_people_f.sex%TYPE;

650: l_name per_all_people_f.full_name%TYPE;
651: l_emp_title per_all_people_f.title%TYPE;
652: l_emp_fath_title per_all_people_f.title%TYPE;
653: l_father_name per_all_people_f.full_name%TYPE;
654: l_gender per_all_people_f.sex%TYPE;
655: l_pos per_all_positions.name%TYPE;
656: l_employee_address per_addresses.address_id%TYPE;
657: l_employee_address_type per_addresses.address_type%TYPE;
658: l_phone_no per_phones.phone_number%TYPE;

Line 2430: FROM per_all_people_f pep

2426: SELECT DECODE(pea.title,NULL,hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
2427: ,SUBSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
2428: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1)) father
2429: ,pea.title title
2430: FROM per_all_people_f pep
2431: ,per_all_people_f pea
2432: ,per_contact_relationships con
2433: WHERE pep.person_id = p_person_id
2434: AND pea.person_id =con.contact_person_id

Line 2431: ,per_all_people_f pea

2427: ,SUBSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
2428: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1)) father
2429: ,pea.title title
2430: FROM per_all_people_f pep
2431: ,per_all_people_f pea
2432: ,per_contact_relationships con
2433: WHERE pep.person_id = p_person_id
2434: AND pea.person_id =con.contact_person_id
2435: AND pep.business_group_id = g_bg_id

Line 2451: ,per_all_people_f pep

2447: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) rep_name
2448: ,pep.title title
2449: FROM hr_organization_information hoi
2450: ,hr_organization_units hou
2451: ,per_all_people_f pep
2452: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2453: AND hoi.organization_id = p_gre_id
2454: AND hou.organization_id = hoi.organization_id
2455: AND hou.business_group_id = g_bg_id

Line 2502: l_rep_person_id per_all_people_f.person_id%TYPE;

2498: l_org_name hr_organization_units.name%TYPE;
2499: l_location_id hr_organization_units.location_id%TYPE;
2500: l_pan hr_organization_information.org_information3%TYPE;
2501: l_legal_name hr_organization_information.org_information4%TYPE;
2502: l_rep_person_id per_all_people_f.person_id%TYPE;
2503: l_rep_name per_all_people_f.full_name%TYPE;
2504: l_position per_all_positions.name%TYPE;
2505: l_rep_father per_all_people_f.full_name%TYPE;
2506: l_rep_location hr_organization_units.location_id%TYPE;

Line 2503: l_rep_name per_all_people_f.full_name%TYPE;

2499: l_location_id hr_organization_units.location_id%TYPE;
2500: l_pan hr_organization_information.org_information3%TYPE;
2501: l_legal_name hr_organization_information.org_information4%TYPE;
2502: l_rep_person_id per_all_people_f.person_id%TYPE;
2503: l_rep_name per_all_people_f.full_name%TYPE;
2504: l_position per_all_positions.name%TYPE;
2505: l_rep_father per_all_people_f.full_name%TYPE;
2506: l_rep_location hr_organization_units.location_id%TYPE;
2507: l_rep_phone_no per_phones.phone_number%TYPE;

Line 2505: l_rep_father per_all_people_f.full_name%TYPE;

2501: l_legal_name hr_organization_information.org_information4%TYPE;
2502: l_rep_person_id per_all_people_f.person_id%TYPE;
2503: l_rep_name per_all_people_f.full_name%TYPE;
2504: l_position per_all_positions.name%TYPE;
2505: l_rep_father per_all_people_f.full_name%TYPE;
2506: l_rep_location hr_organization_units.location_id%TYPE;
2507: l_rep_phone_no per_phones.phone_number%TYPE;
2508: l_phone_type per_phones.phone_type%TYPE;
2509: l_rep_father_title per_all_people_f.title%TYPE;

Line 2509: l_rep_father_title per_all_people_f.title%TYPE;

2505: l_rep_father per_all_people_f.full_name%TYPE;
2506: l_rep_location hr_organization_units.location_id%TYPE;
2507: l_rep_phone_no per_phones.phone_number%TYPE;
2508: l_phone_type per_phones.phone_type%TYPE;
2509: l_rep_father_title per_all_people_f.title%TYPE;
2510: l_rep_title per_all_people_f.title%TYPE;
2511: l_rep_work_fax per_phones.phone_number%TYPE;
2512: l_action_info_id NUMBER;
2513: l_ovn NUMBER;

Line 2510: l_rep_title per_all_people_f.title%TYPE;

2506: l_rep_location hr_organization_units.location_id%TYPE;
2507: l_rep_phone_no per_phones.phone_number%TYPE;
2508: l_phone_type per_phones.phone_type%TYPE;
2509: l_rep_father_title per_all_people_f.title%TYPE;
2510: l_rep_title per_all_people_f.title%TYPE;
2511: l_rep_work_fax per_phones.phone_number%TYPE;
2512: l_action_info_id NUMBER;
2513: l_ovn NUMBER;
2514: l_message VARCHAR2(255);