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 243: l_person_id per_people_f.person_id%TYPE;

239: payroll_action_id = pactid;
240:
241: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
242: str varchar2(1000);
243: l_person_id per_people_f.person_id%TYPE;
244: l_assignment_set_id pay_payroll_actions.assignment_set_id%TYPE;
245: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
246:
247: begin

Line 873: l_person_id per_people_f.person_id%type;

869: l_start_date DATE;
870:
871: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
872: str varchar2(1000);
873: l_person_id per_people_f.person_id%type;
874: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;
875: l_effective_date pay_payroll_actions.effective_date%type;
876: l_effective_date1 pay_payroll_actions.effective_date%type;
877: l_business_group_id pay_payroll_actions.business_group_id%type;

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

890: least(l_effective_date,paf.effective_end_date) between
891: paf.effective_start_date and
892: paf.effective_end_date;
893:
894: cursor cur_paf(b_person_id per_people_f.person_id%type,
895: b_start_date DATE,
896: b_end_date DATE)
897: is select
898: paf.assignment_id assignment_id,

Line 1119: per_people_f ppf

1115: cursor cur_ppf is
1116: select
1117: full_name
1118: from
1119: per_people_f ppf
1120: where
1121: ppf.person_id = p_person_id and
1122: p_roe_date between ppf.effective_start_date and
1123: ppf.effective_end_date;

Line 1125: l_full_name per_people_f.full_name%TYPE;

1121: ppf.person_id = p_person_id and
1122: p_roe_date between ppf.effective_start_date and
1123: ppf.effective_end_date;
1124:
1125: l_full_name per_people_f.full_name%TYPE;
1126:
1127: begin
1128:
1129: v_assignment_id := get_user_entity('ROE_ASSIGNMENT_ID');

Line 1751: l_person_id per_people_f.person_id%TYPE;

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

Line 1934: per_people_f people1,

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

Line 1935: per_people_f people2

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

Line 2094: l_roe_contact_person per_people_f.full_name%TYPE;

2090: l_asg_set_name hr_assignment_sets.assignment_set_name%TYPE;
2091: l_first_day_worked date;
2092: l_final_pay_period_end_date date;
2093: l_final_pay_period_start_date date;
2094: l_roe_contact_person per_people_f.full_name%TYPE;
2095: l_roe_contact_first_name per_people_f.first_name%TYPE;
2096: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2097: l_roe_contact_last_name per_people_f.last_name%TYPE;
2098: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;

Line 2095: l_roe_contact_first_name per_people_f.first_name%TYPE;

2091: l_first_day_worked date;
2092: l_final_pay_period_end_date date;
2093: l_final_pay_period_start_date date;
2094: l_roe_contact_person per_people_f.full_name%TYPE;
2095: l_roe_contact_first_name per_people_f.first_name%TYPE;
2096: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2097: l_roe_contact_last_name per_people_f.last_name%TYPE;
2098: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2099: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;

Line 2096: l_roe_contact_middle_names per_people_f.middle_names%TYPE;

2092: l_final_pay_period_end_date date;
2093: l_final_pay_period_start_date date;
2094: l_roe_contact_person per_people_f.full_name%TYPE;
2095: l_roe_contact_first_name per_people_f.first_name%TYPE;
2096: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2097: l_roe_contact_last_name per_people_f.last_name%TYPE;
2098: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2099: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2100: l_roe_correspondence_language per_people_f.full_name%TYPE;

Line 2097: l_roe_contact_last_name per_people_f.last_name%TYPE;

2093: l_final_pay_period_start_date date;
2094: l_roe_contact_person per_people_f.full_name%TYPE;
2095: l_roe_contact_first_name per_people_f.first_name%TYPE;
2096: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2097: l_roe_contact_last_name per_people_f.last_name%TYPE;
2098: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2099: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2100: l_roe_correspondence_language per_people_f.full_name%TYPE;
2101: l_pay_period_end_date date;

Line 2100: l_roe_correspondence_language per_people_f.full_name%TYPE;

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