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 582: ,per_all_people_f pep

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

Line 614: FROM per_all_people_f pep

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

Line 615: ,per_all_people_f pea

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

Line 647: l_person_id per_all_people_f.person_id%TYPE;

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

Line 649: l_pan per_all_people_f.per_information4%TYPE;

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

Line 650: l_residential_status per_all_people_f.per_information7%TYPE;

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

Line 651: l_name per_all_people_f.full_name%TYPE;

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

Line 652: l_emp_title per_all_people_f.title%TYPE;

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

Line 653: l_emp_fath_title per_all_people_f.title%TYPE;

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

Line 654: l_father_name per_all_people_f.full_name%TYPE;

650: l_residential_status per_all_people_f.per_information7%TYPE;
651: l_name per_all_people_f.full_name%TYPE;
652: l_emp_title per_all_people_f.title%TYPE;
653: l_emp_fath_title per_all_people_f.title%TYPE;
654: l_father_name per_all_people_f.full_name%TYPE;
655: l_gender per_all_people_f.sex%TYPE;
656: l_pos per_all_positions.name%TYPE;
657: l_job per_jobs.name%TYPE;
658: l_email_address per_all_people_f.email_address%TYPE;

Line 655: l_gender per_all_people_f.sex%TYPE;

651: l_name per_all_people_f.full_name%TYPE;
652: l_emp_title per_all_people_f.title%TYPE;
653: l_emp_fath_title per_all_people_f.title%TYPE;
654: l_father_name per_all_people_f.full_name%TYPE;
655: l_gender per_all_people_f.sex%TYPE;
656: l_pos per_all_positions.name%TYPE;
657: l_job per_jobs.name%TYPE;
658: l_email_address per_all_people_f.email_address%TYPE;
659: l_employee_address per_addresses.address_id%TYPE;

Line 658: l_email_address per_all_people_f.email_address%TYPE;

654: l_father_name per_all_people_f.full_name%TYPE;
655: l_gender per_all_people_f.sex%TYPE;
656: l_pos per_all_positions.name%TYPE;
657: l_job per_jobs.name%TYPE;
658: l_email_address per_all_people_f.email_address%TYPE;
659: l_employee_address per_addresses.address_id%TYPE;
660: l_employee_address_type per_addresses.address_type%TYPE;
661: l_phone_no per_phones.phone_number%TYPE;
662: l_phone_type per_phones.phone_type%TYPE;

Line 2496: FROM per_all_people_f pep

2492: SELECT DECODE(pea.title,NULL,hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
2493: ,SUBSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
2494: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1)) father
2495: ,pea.title title
2496: FROM per_all_people_f pep
2497: ,per_all_people_f pea
2498: ,per_contact_relationships con
2499: WHERE pep.person_id = p_person_id
2500: AND pea.person_id =con.contact_person_id

Line 2497: ,per_all_people_f pea

2493: ,SUBSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title)
2494: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1)) father
2495: ,pea.title title
2496: FROM per_all_people_f pep
2497: ,per_all_people_f pea
2498: ,per_contact_relationships con
2499: WHERE pep.person_id = p_person_id
2500: AND pea.person_id =con.contact_person_id
2501: AND pep.business_group_id = g_bg_id

Line 2517: ,per_all_people_f pep

2513: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) rep_name
2514: ,pep.title title
2515: FROM hr_organization_information hoi
2516: ,hr_organization_units hou
2517: ,per_all_people_f pep
2518: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2519: AND hoi.organization_id = p_gre_id
2520: AND hou.organization_id = hoi.organization_id
2521: AND hou.business_group_id = g_bg_id

Line 2568: l_rep_person_id per_all_people_f.person_id%TYPE;

2564: l_org_name hr_organization_units.name%TYPE;
2565: l_location_id hr_organization_units.location_id%TYPE;
2566: l_pan hr_organization_information.org_information3%TYPE;
2567: l_legal_name hr_organization_information.org_information4%TYPE;
2568: l_rep_person_id per_all_people_f.person_id%TYPE;
2569: l_rep_name per_all_people_f.full_name%TYPE;
2570: l_position per_all_positions.name%TYPE;
2571: l_job per_jobs.name%TYPE;
2572: l_rep_father per_all_people_f.full_name%TYPE;

Line 2569: l_rep_name per_all_people_f.full_name%TYPE;

2565: l_location_id hr_organization_units.location_id%TYPE;
2566: l_pan hr_organization_information.org_information3%TYPE;
2567: l_legal_name hr_organization_information.org_information4%TYPE;
2568: l_rep_person_id per_all_people_f.person_id%TYPE;
2569: l_rep_name per_all_people_f.full_name%TYPE;
2570: l_position per_all_positions.name%TYPE;
2571: l_job per_jobs.name%TYPE;
2572: l_rep_father per_all_people_f.full_name%TYPE;
2573: l_rep_location hr_organization_units.location_id%TYPE;

Line 2572: l_rep_father per_all_people_f.full_name%TYPE;

2568: l_rep_person_id per_all_people_f.person_id%TYPE;
2569: l_rep_name per_all_people_f.full_name%TYPE;
2570: l_position per_all_positions.name%TYPE;
2571: l_job per_jobs.name%TYPE;
2572: l_rep_father per_all_people_f.full_name%TYPE;
2573: l_rep_location hr_organization_units.location_id%TYPE;
2574: l_rep_phone_no per_phones.phone_number%TYPE;
2575: l_phone_type per_phones.phone_type%TYPE;
2576: l_rep_father_title per_all_people_f.title%TYPE;

Line 2576: l_rep_father_title per_all_people_f.title%TYPE;

2572: l_rep_father per_all_people_f.full_name%TYPE;
2573: l_rep_location hr_organization_units.location_id%TYPE;
2574: l_rep_phone_no per_phones.phone_number%TYPE;
2575: l_phone_type per_phones.phone_type%TYPE;
2576: l_rep_father_title per_all_people_f.title%TYPE;
2577: l_rep_title per_all_people_f.title%TYPE;
2578: l_rep_work_fax per_phones.phone_number%TYPE;
2579: l_action_info_id NUMBER;
2580: l_ovn NUMBER;

Line 2577: l_rep_title per_all_people_f.title%TYPE;

2573: l_rep_location hr_organization_units.location_id%TYPE;
2574: l_rep_phone_no per_phones.phone_number%TYPE;
2575: l_phone_type per_phones.phone_type%TYPE;
2576: l_rep_father_title per_all_people_f.title%TYPE;
2577: l_rep_title per_all_people_f.title%TYPE;
2578: l_rep_work_fax per_phones.phone_number%TYPE;
2579: l_action_info_id NUMBER;
2580: l_ovn NUMBER;
2581: l_message VARCHAR2(255);