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_CA_ARCHIVE dependencies on PER_PEOPLE_F

Line 239: l_person_id per_people_f.person_id%TYPE;

235: payroll_action_id = pactid;
236:
237: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
238: str varchar2(1000);
239: l_person_id per_people_f.person_id%TYPE;
240: l_assignment_set_id pay_payroll_actions.assignment_set_id%TYPE;
241: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
242:
243: begin

Line 869: l_person_id per_people_f.person_id%type;

865: l_start_date DATE;
866:
867: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
868: str varchar2(1000);
869: l_person_id per_people_f.person_id%type;
870: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;
871: l_effective_date pay_payroll_actions.effective_date%type;
872: l_effective_date1 pay_payroll_actions.effective_date%type;
873: l_business_group_id pay_payroll_actions.business_group_id%type;

Line 890: cursor cur_paf(b_person_id per_people_f.person_id%type,

886: least(l_effective_date,paf.effective_end_date) between
887: paf.effective_start_date and
888: paf.effective_end_date;
889:
890: cursor cur_paf(b_person_id per_people_f.person_id%type,
891: b_start_date DATE,
892: b_end_date DATE)
893: is select
894: paf.assignment_id assignment_id,

Line 1115: per_people_f ppf

1111: cursor cur_ppf is
1112: select
1113: full_name
1114: from
1115: per_people_f ppf
1116: where
1117: ppf.person_id = p_person_id and
1118: p_roe_date between ppf.effective_start_date and
1119: ppf.effective_end_date;

Line 1121: l_full_name per_people_f.full_name%TYPE;

1117: ppf.person_id = p_person_id and
1118: p_roe_date between ppf.effective_start_date and
1119: ppf.effective_end_date;
1120:
1121: l_full_name per_people_f.full_name%TYPE;
1122:
1123: begin
1124:
1125: v_assignment_id := get_user_entity('ROE_ASSIGNMENT_ID');

Line 1747: l_person_id per_people_f.person_id%TYPE;

1743: l_effective_date pay_payroll_actions.effective_date%type;
1744: l_business_group_id pay_payroll_actions.business_group_id%type;
1745: total_no_fields number;
1746: l_payroll_id pay_payroll_actions.payroll_id%type;
1747: l_person_id per_people_f.person_id%TYPE;
1748: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
1749:
1750:
1751: cursor cur_person_id(p_assignment_action_id number) is

Line 1930: per_people_f people1,

1926: people1.first_name contact_first_name,
1927: people1.middle_names contact_middle_names,
1928: people1.last_name contact_last_name
1929: from pay_payrolls_f ppf,
1930: per_people_f people1,
1931: per_people_f people2
1932: where ppf.payroll_id = l_payroll_id
1933: and ppf.prl_information_category = 'CA'
1934: and ppf.prl_information1 = people1.person_id(+)

Line 1931: per_people_f people2

1927: people1.middle_names contact_middle_names,
1928: people1.last_name contact_last_name
1929: from pay_payrolls_f ppf,
1930: per_people_f people1,
1931: per_people_f people2
1932: where ppf.payroll_id = l_payroll_id
1933: and ppf.prl_information_category = 'CA'
1934: and ppf.prl_information1 = people1.person_id(+)
1935: and ppf.prl_information3 = people2.person_id(+)

Line 2090: l_roe_contact_person per_people_f.full_name%TYPE;

2086: l_asg_set_name hr_assignment_sets.assignment_set_name%TYPE;
2087: l_first_day_worked date;
2088: l_final_pay_period_end_date date;
2089: l_final_pay_period_start_date date;
2090: l_roe_contact_person per_people_f.full_name%TYPE;
2091: l_roe_contact_first_name per_people_f.first_name%TYPE;
2092: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2093: l_roe_contact_last_name per_people_f.last_name%TYPE;
2094: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;

Line 2091: l_roe_contact_first_name per_people_f.first_name%TYPE;

2087: l_first_day_worked date;
2088: l_final_pay_period_end_date date;
2089: l_final_pay_period_start_date date;
2090: l_roe_contact_person per_people_f.full_name%TYPE;
2091: l_roe_contact_first_name per_people_f.first_name%TYPE;
2092: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2093: l_roe_contact_last_name per_people_f.last_name%TYPE;
2094: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2095: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;

Line 2092: l_roe_contact_middle_names per_people_f.middle_names%TYPE;

2088: l_final_pay_period_end_date date;
2089: l_final_pay_period_start_date date;
2090: l_roe_contact_person per_people_f.full_name%TYPE;
2091: l_roe_contact_first_name per_people_f.first_name%TYPE;
2092: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2093: l_roe_contact_last_name per_people_f.last_name%TYPE;
2094: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2095: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2096: l_roe_correspondence_language per_people_f.full_name%TYPE;

Line 2093: l_roe_contact_last_name per_people_f.last_name%TYPE;

2089: l_final_pay_period_start_date date;
2090: l_roe_contact_person per_people_f.full_name%TYPE;
2091: l_roe_contact_first_name per_people_f.first_name%TYPE;
2092: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2093: l_roe_contact_last_name per_people_f.last_name%TYPE;
2094: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2095: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2096: l_roe_correspondence_language per_people_f.full_name%TYPE;
2097: l_pay_period_end_date date;

Line 2096: l_roe_correspondence_language per_people_f.full_name%TYPE;

2092: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2093: l_roe_contact_last_name per_people_f.last_name%TYPE;
2094: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2095: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2096: l_roe_correspondence_language per_people_f.full_name%TYPE;
2097: l_pay_period_end_date date;
2098: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2099: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE
2100: := 0;