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

Line 586: l_person_id per_all_people_f.person_id%TYPE;

582: p_assactid in number
583: ,p_effective_date in date) is
584: --
585: l_establishment_id pay_assignment_actions.tax_unit_id%TYPE;
586: l_person_id per_all_people_f.person_id%TYPE;
587: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
588: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
589: l_latest_assignment_action_id pay_assignment_actions.assignment_id%TYPE;
590: l_latest_date_paid date;

Line 1213: l_person_id per_all_people_f.person_id%TYPE;

1209: ,p_assignment_id out nocopy number
1210: ,p_payroll_id out nocopy number) is
1211: --
1212: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1213: l_person_id per_all_people_f.person_id%TYPE;
1214: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1215: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
1216: --
1217: l_proc VARCHAR2(40):= g_package||' get_instance_variables ';

Line 1590: l_ee_last_name per_all_people_f.last_name%TYPE;

1586: --
1587: -- ee details cursor items
1588: --
1589: l_ee_soc_sec_number varchar2(30);
1590: l_ee_last_name per_all_people_f.last_name%TYPE;
1591: l_ee_first_name per_all_people_f.first_name%TYPE;
1592: l_ee_full_name per_all_people_f.full_name%TYPE;
1593: l_ee_job_name per_jobs.name%TYPE;
1594: l_ee_job_id per_jobs.job_id%type;

Line 1591: l_ee_first_name per_all_people_f.first_name%TYPE;

1587: -- ee details cursor items
1588: --
1589: l_ee_soc_sec_number varchar2(30);
1590: l_ee_last_name per_all_people_f.last_name%TYPE;
1591: l_ee_first_name per_all_people_f.first_name%TYPE;
1592: l_ee_full_name per_all_people_f.full_name%TYPE;
1593: l_ee_job_name per_jobs.name%TYPE;
1594: l_ee_job_id per_jobs.job_id%type;
1595: l_ee_job_definition_id per_jobs.job_definition_id%type;

Line 1592: l_ee_full_name per_all_people_f.full_name%TYPE;

1588: --
1589: l_ee_soc_sec_number varchar2(30);
1590: l_ee_last_name per_all_people_f.last_name%TYPE;
1591: l_ee_first_name per_all_people_f.first_name%TYPE;
1592: l_ee_full_name per_all_people_f.full_name%TYPE;
1593: l_ee_job_name per_jobs.name%TYPE;
1594: l_ee_job_id per_jobs.job_id%type;
1595: l_ee_job_definition_id per_jobs.job_definition_id%type;
1596: l_ee_position_name per_positions.name%TYPE;

Line 1600: l_ee_maiden_name per_all_people_f.previous_last_name%TYPE;

1596: l_ee_position_name per_positions.name%TYPE;
1597: l_ee_coll_agree_name per_collective_agreements.name%TYPE;
1598: l_ee_coy_id varchar2(150);
1599: l_ee_payroll_id per_all_assignments_f.payroll_id%TYPE;
1600: l_ee_maiden_name per_all_people_f.previous_last_name%TYPE;
1601: l_ee_assignment_number per_all_assignments_f.assignment_number%TYPE;
1602: l_ee_org_name hr_all_organization_units.name%TYPE;
1603: --
1604: NO_ADDRESS EXCEPTION; /* error as must be sent to a home address */

Line 1666: ,per_all_people_f peo

1662: ,ctr.ctr_information13 Con_Frequency
1663: ,hrl1.meaning Con_freq_mean
1664: from
1665: per_all_assignments_f asg
1666: ,per_all_people_f peo
1667: ,per_jobs job
1668: ,hr_all_positions_f_tl postl
1669: ,per_collective_agreements cag
1670: ,hr_all_organization_units est