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 502: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is

498: and hou.business_group_id= c_bg_id
499: and hoi.ORG_INFORMATION1 = p_year
500: and hoi.ORG_INFORMATION2 = p_qtr;
501: /*
502: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is
503: select papf.full_name declarant_name
504: ,pav.telephone_number_1 declarant_phone
505: ,papf.email_address declarant_email
506: ,pap.NAME declarant_position

Line 507: from per_all_people_f papf

503: select papf.full_name declarant_name
504: ,pav.telephone_number_1 declarant_phone
505: ,papf.email_address declarant_email
506: ,pap.NAME declarant_position
507: from per_all_people_f papf
508: ,per_all_assignments_f paaf
509: ,per_all_positions pap
510: ,per_addresses_v pav
511: where papf.person_id=c_person_id ;

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

515: and g_archive_effective_date between paaf.effective_start_date and paaf.effective_end_date
516: and g_archive_effective_date between papf.effective_start_date and papf.effective_end_date;
517: */
518: /* bug 6850742 */
519: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is
520: select papf.full_name declarant_name
521: from per_all_people_f papf
522: where papf.person_id=c_person_id ;
523:

Line 521: from per_all_people_f papf

517: */
518: /* bug 6850742 */
519: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is
520: select papf.full_name declarant_name
521: from per_all_people_f papf
522: where papf.person_id=c_person_id ;
523:
524:
525: l_employer_details csr_employer_details%rowtype;

Line 540: l_declarant_name per_all_people_f.full_name%type;

536: l_addr4 hr_locations_all.address_line_3%type;
537: l_addr5 hr_locations_all.address_line_3%type;
538: l_cbr_no hr_organization_information.org_information3%type;
539: l_person_id hr_organization_information.org_information13%type;
540: l_declarant_name per_all_people_f.full_name%type;
541: l_declarant_phone per_all_people_f.office_number%type ;
542: l_declarant_email_add per_all_people_f.email_address%type;
543: l_declarant_position per_all_positions.name%type;
544:

Line 541: l_declarant_phone per_all_people_f.office_number%type ;

537: l_addr5 hr_locations_all.address_line_3%type;
538: l_cbr_no hr_organization_information.org_information3%type;
539: l_person_id hr_organization_information.org_information13%type;
540: l_declarant_name per_all_people_f.full_name%type;
541: l_declarant_phone per_all_people_f.office_number%type ;
542: l_declarant_email_add per_all_people_f.email_address%type;
543: l_declarant_position per_all_positions.name%type;
544:
545:

Line 542: l_declarant_email_add per_all_people_f.email_address%type;

538: l_cbr_no hr_organization_information.org_information3%type;
539: l_person_id hr_organization_information.org_information13%type;
540: l_declarant_name per_all_people_f.full_name%type;
541: l_declarant_phone per_all_people_f.office_number%type ;
542: l_declarant_email_add per_all_people_f.email_address%type;
543: l_declarant_position per_all_positions.name%type;
544:
545:
546: BEGIN

Line 790: per_all_people_f ppf,

786: hr_utility.set_location('Before building the dynamic query.',510);
787: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
788: l_select_str :='select distinct paaf.assignment_id asgid
789: from per_all_assignments_f paaf,
790: per_all_people_f ppf,
791: pay_all_payrolls_f papf,
792: pay_payroll_actions ppa,
793: hr_soft_coding_keyflex scl
794: where paaf.business_group_id = '|| g_business_group_id

Line 1755: l_person_id per_all_people_f.person_id%TYPE;

1751: l_string varchar2(32767) := NULL;
1752: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1753: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1754:
1755: l_person_id per_all_people_f.person_id%TYPE;
1756: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1757: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1758: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
1759:

Line 1762: FROM per_all_people_f ppf

1758: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
1759:
1760: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
1761: SELECT DISTINCT ppf.person_id, paa.assignment_id
1762: FROM per_all_people_f ppf
1763: ,per_all_assignments_f paa
1764: ,pay_payroll_actions ppa
1765: ,pay_temp_object_actions ptoa
1766: WHERE paa.business_group_id = ppa.business_group_id