[Home] [Help]
155: l_action_type pay_payroll_actions.action_type%type;
156: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
157: l_assignment_id pay_assignment_actions.assignment_id%type;
158: l_tax_unit_id hr_organization_units.organization_id%type;
159: l_person_id per_all_people_f.person_id%TYPE; -- #1937448
160: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
161: l_gre_name hr_organization_units.name%type;
162: l_organization_id hr_organization_units.organization_id%type;
163: l_org_name hr_organization_units.name%type;
173: t_gre_id number(15);
174: t_payroll_action_id pay_payroll_actions.payroll_action_id%type;
175: l_defined_balance_id number;
176: l_row_count number;
177: l_full_name per_all_people_f.full_name%TYPE;
178: l_asg_flag varchar2(1);
179:
180: ----------------------------------------------------------------------------------
181: /*-- Bug#4942114 starts -- */
1834: l_dummy_var varchar2(1);
1835:
1836: -- #1937448
1837:
1838: l_full_name per_all_people_f.full_name%TYPE;
1839: l_payment_method_name pay_org_payment_methods_f.org_payment_method_name%TYPE;
1840: l_account_type fnd_common_lookups.meaning%TYPE;
1841: l_account_number pay_external_accounts.segment3%TYPE;
1842: l_routing_number pay_external_accounts.segment4%TYPE;
1842: l_routing_number pay_external_accounts.segment4%TYPE;
1843:
1844: cursor person_details is -- #1937448
1845: select ppf.full_name
1846: from per_all_people_f ppf
1847: where ppf.person_id = l_person_id
1848: and l_effective_date
1849: between ppf.effective_start_date and ppf.effective_end_date ;
1850:
2867: cursor sel_empname(l_person_id number,l_effective_date date)
2868: is
2869: select
2870: ppf.full_name
2871: from per_all_people_f ppf
2872: where ppf.person_id = l_person_id
2873: and l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
2874: l_chnk_number number;
2875: