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

Line 574: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is

570: and hou.business_group_id= c_bg_id
571: and hoi.ORG_INFORMATION1 = p_year
572: and hoi.ORG_INFORMATION2 = p_qtr;
573: /*
574: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is
575: select papf.full_name declarant_name
576: ,pav.telephone_number_1 declarant_phone
577: ,papf.email_address declarant_email
578: ,pap.NAME declarant_position

Line 579: from per_all_people_f papf

575: select papf.full_name declarant_name
576: ,pav.telephone_number_1 declarant_phone
577: ,papf.email_address declarant_email
578: ,pap.NAME declarant_position
579: from per_all_people_f papf
580: ,per_all_assignments_f paaf
581: ,per_all_positions pap
582: ,per_addresses_v pav
583: where papf.person_id=c_person_id ;

Line 591: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is

587: and g_archive_effective_date between paaf.effective_start_date and paaf.effective_end_date
588: and g_archive_effective_date between papf.effective_start_date and papf.effective_end_date;
589: */
590: /* bug 6850742 */
591: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is
592: select papf.full_name declarant_name
593: from per_all_people_f papf
594: where papf.person_id=c_person_id ;
595:

Line 593: from per_all_people_f papf

589: */
590: /* bug 6850742 */
591: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is
592: select papf.full_name declarant_name
593: from per_all_people_f papf
594: where papf.person_id=c_person_id ;
595:
596:
597: l_employer_details csr_employer_details%rowtype;

Line 612: l_declarant_name per_all_people_f.full_name%type;

608: l_addr4 hr_locations_all.address_line_3%type;
609: l_addr5 hr_locations_all.address_line_3%type;
610: l_cbr_no hr_organization_information.org_information3%type;
611: l_person_id hr_organization_information.org_information13%type;
612: l_declarant_name per_all_people_f.full_name%type;
613: l_declarant_phone per_all_people_f.office_number%type ;
614: l_declarant_email_add per_all_people_f.email_address%type;
615: l_declarant_position per_all_positions.name%type;
616:

Line 613: l_declarant_phone per_all_people_f.office_number%type ;

609: l_addr5 hr_locations_all.address_line_3%type;
610: l_cbr_no hr_organization_information.org_information3%type;
611: l_person_id hr_organization_information.org_information13%type;
612: l_declarant_name per_all_people_f.full_name%type;
613: l_declarant_phone per_all_people_f.office_number%type ;
614: l_declarant_email_add per_all_people_f.email_address%type;
615: l_declarant_position per_all_positions.name%type;
616:
617: /* 9719281 */

Line 614: l_declarant_email_add per_all_people_f.email_address%type;

610: l_cbr_no hr_organization_information.org_information3%type;
611: l_person_id hr_organization_information.org_information13%type;
612: l_declarant_name per_all_people_f.full_name%type;
613: l_declarant_phone per_all_people_f.office_number%type ;
614: l_declarant_email_add per_all_people_f.email_address%type;
615: l_declarant_position per_all_positions.name%type;
616:
617: /* 9719281 */
618: --

Line 964: per_all_people_f ppf,

960: hr_utility.set_location('Before building the dynamic query.',510);
961: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
962: l_select_str :='select distinct paaf.assignment_id asgid
963: from per_all_assignments_f paaf,
964: per_all_people_f ppf,
965: pay_all_payrolls_f papf,
966: pay_payroll_actions ppa,
967: hr_soft_coding_keyflex scl
968: where paaf.business_group_id = '|| g_business_group_id

Line 2038: l_person_id per_all_people_f.person_id%TYPE;

2034: l_string varchar2(32767) := NULL;
2035: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2036: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2037:
2038: l_person_id per_all_people_f.person_id%TYPE;
2039: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2040: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2041: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
2042:

Line 2045: FROM per_all_people_f ppf

2041: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
2042:
2043: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
2044: SELECT DISTINCT ppf.person_id, paa.assignment_id
2045: FROM per_all_people_f ppf
2046: ,per_all_assignments_f paa
2047: ,pay_payroll_actions ppa
2048: ,pay_temp_object_actions ptoa
2049: WHERE paa.business_group_id = ppa.business_group_id