[Home] [Help]
131: l_action_type pay_payroll_actions.action_type%type;
132: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
133: l_assignment_id pay_assignment_actions.assignment_id%type;
134: l_tax_unit_id hr_organization_units.organization_id%type;
135: l_person_id per_all_people_f.person_id%TYPE; -- #1937448
136: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
137: l_gre_name hr_organization_units.name%type;
138: l_organization_id hr_organization_units.organization_id%type;
139: l_org_name hr_organization_units.name%type;
149: t_gre_id number(15);
150: t_payroll_action_id pay_payroll_actions.payroll_action_id%type;
151: l_defined_balance_id number;
152: l_row_count number;
153: l_full_name per_all_people_f.full_name%TYPE;
154: l_asg_flag varchar2(1);
155:
156: ----------------------------------------------------------------------------------
157: /*-- Bug#4942114 starts -- */
1655: l_dummy_var varchar2(1);
1656:
1657: -- #1937448
1658:
1659: l_full_name per_all_people_f.full_name%TYPE;
1660: l_payment_method_name pay_org_payment_methods_f.org_payment_method_name%TYPE;
1661: l_account_type fnd_common_lookups.meaning%TYPE;
1662: l_account_number pay_external_accounts.segment3%TYPE;
1663: l_routing_number pay_external_accounts.segment4%TYPE;
1663: l_routing_number pay_external_accounts.segment4%TYPE;
1664:
1665: cursor person_details is -- #1937448
1666: select ppf.full_name
1667: from per_all_people_f ppf
1668: where ppf.person_id = l_person_id
1669: and l_effective_date
1670: between ppf.effective_start_date and ppf.effective_end_date ;
1671:
2655: cursor sel_empname(l_person_id number,l_effective_date date)
2656: is
2657: select
2658: ppf.full_name
2659: from per_all_people_f ppf
2660: where ppf.person_id = l_person_id
2661: and l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
2662: l_chnk_number number;
2663: begin