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

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

619: and hou.business_group_id= c_bg_id
620: and hoi.ORG_INFORMATION1 = p_year
621: and hoi.ORG_INFORMATION2 = p_qtr;
622:
623: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is
624: select papf.full_name declarant_name
625: from per_all_people_f papf
626: where papf.person_id=c_person_id ;
627:

Line 625: from per_all_people_f papf

621: and hoi.ORG_INFORMATION2 = p_qtr;
622:
623: CURSOR csr_declarant_details(c_person_id per_all_people_f.person_id%type) is
624: select papf.full_name declarant_name
625: from per_all_people_f papf
626: where papf.person_id=c_person_id ;
627:
628:
629: l_employer_details csr_employer_details%rowtype;

Line 644: l_declarant_name per_all_people_f.full_name%type;

640: l_addr4 hr_locations_all.address_line_3%type;
641: l_addr5 hr_locations_all.address_line_3%type;
642: l_cbr_no hr_organization_information.org_information3%type;
643: l_person_id hr_organization_information.org_information13%type;
644: l_declarant_name per_all_people_f.full_name%type;
645: l_declarant_phone per_all_people_f.office_number%type ;
646: l_declarant_email_add per_all_people_f.email_address%type;
647: l_declarant_position per_all_positions.name%type;
648:

Line 645: l_declarant_phone per_all_people_f.office_number%type ;

641: l_addr5 hr_locations_all.address_line_3%type;
642: l_cbr_no hr_organization_information.org_information3%type;
643: l_person_id hr_organization_information.org_information13%type;
644: l_declarant_name per_all_people_f.full_name%type;
645: l_declarant_phone per_all_people_f.office_number%type ;
646: l_declarant_email_add per_all_people_f.email_address%type;
647: l_declarant_position per_all_positions.name%type;
648:
649: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;

Line 646: l_declarant_email_add per_all_people_f.email_address%type;

642: l_cbr_no hr_organization_information.org_information3%type;
643: l_person_id hr_organization_information.org_information13%type;
644: l_declarant_name per_all_people_f.full_name%type;
645: l_declarant_phone per_all_people_f.office_number%type ;
646: l_declarant_email_add per_all_people_f.email_address%type;
647: l_declarant_position per_all_positions.name%type;
648:
649: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;
650: pl_address tab_address;

Line 1004: per_all_people_f ppf,

1000: hr_utility.set_location(' g_reference_end_date = '|| g_reference_end_date,505);
1001:
1002: l_select_str1 :='select count (distinct paaf.assignment_id )
1003: from per_all_assignments_f paaf,
1004: per_all_people_f ppf,
1005: pay_all_payrolls_f papf,
1006: pay_payroll_actions ppa,
1007: pay_assignment_actions paa,
1008: hr_soft_coding_keyflex scl

Line 1060: per_all_people_f ppf,

1056: select asgid,round(mod(dbms_random.value*'||g_sample_fraction||','||g_sample_fraction||')) serial '
1057: || 'from ( '
1058: || 'select distinct paaf.assignment_id asgid
1059: from per_all_assignments_f paaf,
1060: per_all_people_f ppf,
1061: pay_all_payrolls_f papf,
1062: pay_payroll_actions ppa,
1063: pay_assignment_actions paa,
1064: hr_soft_coding_keyflex scl

Line 1200: ,per_all_people_f papf -- 9795571

1196: CURSOR cur_get_pactid(p_cess_aact pay_assignment_actions.assignment_action_id%TYPE) IS
1197: SELECT distinct paa.payroll_action_id,paa.assignment_id,paaf.person_id,papf.employee_number
1198: FROM pay_assignment_actions paa
1199: ,per_all_assignments_f paaf
1200: ,per_all_people_f papf -- 9795571
1201: WHERE paa.assignment_action_id = p_cess_aact
1202: and paa.assignment_id=paaf.assignment_id
1203: and papf.person_id=paaf.person_id; -- 9795571
1204:

Line 1315: per_all_people_f papf,

1311: pa.town_or_city city ,
1312: flv.meaning County,
1313: pa.country Country
1314: from per_addresses pa,
1315: per_all_people_f papf,
1316: fnd_lookup_values flv
1317: where papf.person_id = cp_person_id
1318: and papf.person_id=pa.person_id(+)
1319: and pa.primary_flag (+)= 'Y' --is address primary ?

Line 1510: l_employee_number per_all_people_f.employee_number%TYPE;

1506:
1507: l_payroll_action_id number;
1508: l_assignment_id number;
1509: l_person_id number;
1510: l_employee_number per_all_people_f.employee_number%TYPE;
1511: l_reference_date date;
1512: l_ness_assignment_action number;
1513: l_ness_assignment_action_ytd number;
1514: l_action_info_id NUMBER;

Line 3066: l_person_id per_all_people_f.person_id%TYPE;

3062:
3063: l_buf VARCHAR2(2000);
3064: l_proc VARCHAR2(100);
3065:
3066: l_person_id per_all_people_f.person_id%TYPE;
3067: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3068: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
3069: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3070: