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

Line 568: l_rep_name per_all_people_f.full_name%TYPE;

564: period_end DATE;
565: l_date DATE;
566: l_registered_no hr_organization_information.org_information1%TYPE;
567: l_registered_name hr_organization_units.name%TYPE;
568: l_rep_name per_all_people_f.full_name%TYPE;
569: l_rep_desg per_all_positions.name%TYPE;
570: l_org_name hr_organization_units.name%TYPE;
571: l_message VARCHAR2(255);
572: l_procedure VARCHAR2(100);

Line 2292: l_employee_name per_all_people_f.full_name%TYPE;

2288: l_cont_type_date_earned VARCHAR(20):= 'DEFAULT';
2289: l_pf_ceiling_type varchar2(50);
2290:
2291: date_earned DATE;
2292: l_employee_name per_all_people_f.full_name%TYPE;
2293: asg_sum NUMBER := 0;
2294:
2295:
2296: BEGIN

Line 4493: l_rep_name per_all_people_f.full_name%TYPE;

4489:
4490:
4491:
4492: l_reg_name hr_organization_information.org_information1%TYPE;
4493: l_rep_name per_all_people_f.full_name%TYPE;
4494: l_org_address pay_action_information.action_information1%TYPE;
4495: --In the Rarest case of location adddress exceeding 240 characters nothing can be done
4496: l_est_code hr_organization_information.org_information1%TYPE;
4497:

Line 4500: l_employee_name per_all_people_f.full_name%TYPE;

4496: l_est_code hr_organization_information.org_information1%TYPE;
4497:
4498: g_org_XMLTable pay_in_xml_utils.tXMLTable;
4499:
4500: l_employee_name per_all_people_f.full_name%TYPE;
4501: l_fath_husb_name per_all_people_f.full_name%TYPE;
4502: l_hire_date DATE;
4503: l_pension_number per_all_people_f.per_information13%TYPE;
4504:

Line 4501: l_fath_husb_name per_all_people_f.full_name%TYPE;

4497:
4498: g_org_XMLTable pay_in_xml_utils.tXMLTable;
4499:
4500: l_employee_name per_all_people_f.full_name%TYPE;
4501: l_fath_husb_name per_all_people_f.full_name%TYPE;
4502: l_hire_date DATE;
4503: l_pension_number per_all_people_f.per_information13%TYPE;
4504:
4505: l_bg_id NUMBER;

Line 4503: l_pension_number per_all_people_f.per_information13%TYPE;

4499:
4500: l_employee_name per_all_people_f.full_name%TYPE;
4501: l_fath_husb_name per_all_people_f.full_name%TYPE;
4502: l_hire_date DATE;
4503: l_pension_number per_all_people_f.per_information13%TYPE;
4504:
4505: l_bg_id NUMBER;
4506: p_cp_pf_org_id NUMBER;
4507: p_status VARCHAR2(30);

Line 5519: l_rep_name per_all_people_f.full_name%TYPE;

5515: l_payroll_act_id NUMBER;
5516: l_employer_code hr_organization_information.org_information1%TYPE;
5517: l_registered_name hr_organization_units.name%TYPE;
5518: l_reg_address VARCHAR2(240);
5519: l_rep_name per_all_people_f.full_name%TYPE;
5520: l_rep_desg per_all_positions.name%TYPE;
5521: l_rep_addr VARCHAR2(240);
5522: l_org_name hr_organization_units.name%TYPE;
5523: l_person_id NUMBER;

Line 5524: l_insurance_no per_all_people_f.per_information9%TYPE;

5520: l_rep_desg per_all_positions.name%TYPE;
5521: l_rep_addr VARCHAR2(240);
5522: l_org_name hr_organization_units.name%TYPE;
5523: l_person_id NUMBER;
5524: l_insurance_no per_all_people_f.per_information9%TYPE;
5525: l_full_name per_all_people_f.full_name%TYPE;
5526: l_payroll_mon NUMBER;
5527: l_length NUMBER;
5528: l_mon NUMBER;

Line 5525: l_full_name per_all_people_f.full_name%TYPE;

5521: l_rep_addr VARCHAR2(240);
5522: l_org_name hr_organization_units.name%TYPE;
5523: l_person_id NUMBER;
5524: l_insurance_no per_all_people_f.per_information9%TYPE;
5525: l_full_name per_all_people_f.full_name%TYPE;
5526: l_payroll_mon NUMBER;
5527: l_length NUMBER;
5528: l_mon NUMBER;
5529: l_message VARCHAR2(255);