[Home] [Help]
226:
227: p_sqlstr := 'select distinct to_number(emp.person_id)
228: from pay_ca_eoy_rl2_employee_info_v emp,
229: pay_ca_eoy_rl2_trans_info_v tran,
230: pay_assignment_actions paa_arch,
231: pay_payroll_actions ppa_arch,
232: pay_payroll_actions ppa_mag,
233: hr_organization_information hoi
234: where ppa_mag.payroll_action_id = :payroll_action_id
290: paf.effective_end_date,
291: paa_arch.assignment_action_id,
292: ppa_arch.payroll_action_id
293: FROM pay_payroll_actions ppa_arch,
294: pay_assignment_actions paa_arch,
295: per_all_assignments_f paf,
296: hr_organization_information hoi
297: WHERE ppa_arch.report_type = 'RL2'
298: AND ppa_arch.business_group_id+0 = p_business_grpid
426: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
427:
428: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
429:
430: SELECT pay_assignment_actions_s.nextval
431: INTO lockingactid
432: FROM dual;
433:
434: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 50);
1169: to_number(substr(paa.serial_number,3,14)) payactid,
1170: to_number(substr(paa.serial_number,17,14)) asgactid,
1171: paa.assignment_id asgid
1172: FROM
1173: pay_assignment_actions paa
1174: WHERE paa.assignment_action_id = p_payactid;
1175:
1176: CURSOR c_get_report_type(p_payactid NUMBER) IS
1177: SELECT
1208: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1209: -- date_earned
1210: FROM
1211: pay_action_interlocks pai,
1212: pay_assignment_actions paa,
1213: pay_payroll_actions ppa,
1214: per_all_people_f ppf,
1215: per_all_assignments_f paf,
1216: pay_action_information pact
1310: l_rl2_box_o varchar2(240);
1311: l_rl2_source_of_income varchar2(240);
1312: l_negative_balance_flag varchar2(240);
1313:
1314: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1315: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1316: l_asg_id per_assignments_f.assignment_id%TYPE;
1317: l_date_earned DATE;
1318: l_province VARCHAR2(30);
1311: l_rl2_source_of_income varchar2(240);
1312: l_negative_balance_flag varchar2(240);
1313:
1314: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1315: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1316: l_asg_id per_assignments_f.assignment_id%TYPE;
1317: l_date_earned DATE;
1318: l_province VARCHAR2(30);
1319: