APPS.PAY_CA_RL1_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 283: pay_assignment_actions paa,

279: from ff_archive_items fai1,
280: ff_database_items fdi1,
281: ff_archive_items fai2,
282: ff_database_items fdi2,
283: pay_assignment_actions paa,
284: pay_payroll_actions ppa,
285: pay_payroll_actions ppa1,
286: hr_organization_information hoi
287: where ppa1.payroll_action_id = :payroll_action_id

Line 345: pay_assignment_actions paa,

341: paf.effective_end_date,
342: paa.assignment_action_id,
343: ppa.payroll_action_id -- Added by ssmukher for Bug 3353115
344: FROM pay_payroll_actions ppa,
345: pay_assignment_actions paa,
346: per_all_assignments_f paf,
347: pay_payroll_actions ppa1,
348: hr_organization_information hoi
349: WHERE ppa1.payroll_action_id = p_pactid

Line 459: SELECT pay_assignment_actions_s.nextval

455: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
456: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
457: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 40);
458:
459: SELECT pay_assignment_actions_s.nextval
460: INTO lockingactid
461: FROM dual;
462:
463: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 50);

Line 1041: pay_assignment_actions paa

1037: to_number(substr(paa.serial_number,3,14)) asgactid , --archiver assignment action id
1038: to_number(substr(paa.serial_number,17,14)) payactid, --archiver payroll action id
1039: paa.assignment_id asgid
1040: FROM
1041: pay_assignment_actions paa
1042: WHERE paa.assignment_action_id = p_assg_actid;
1043:
1044: cursor c_province( p_arch_asact_id number ) is
1045: select fai.value

Line 1076: pay_assignment_actions paa,

1072: ff_database_items fdi,
1073: per_all_people_f ppf,
1074: per_all_assignments_f paf,
1075: pay_action_interlocks pai,
1076: pay_assignment_actions paa,
1077: pay_payroll_actions ppa,
1078: pay_assignment_actions paa_arch
1079: WHERE
1080: paa.assignment_action_id = p_mag_asg_action_id AND

Line 1078: pay_assignment_actions paa_arch

1074: per_all_assignments_f paf,
1075: pay_action_interlocks pai,
1076: pay_assignment_actions paa,
1077: pay_payroll_actions ppa,
1078: pay_assignment_actions paa_arch
1079: WHERE
1080: paa.assignment_action_id = p_mag_asg_action_id AND
1081: ppa.payroll_action_id = paa.payroll_action_id AND
1082: pai.locking_action_id = paa.assignment_action_id AND

Line 1101: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1097: paa_arch.assignment_action_id = pai.locked_action_id
1098: ORDER BY
1099: ppf.last_name,ppf.first_name,ppf.middle_names;
1100:
1101: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1102: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1103: l_asg_id per_assignments_f.assignment_id%TYPE;
1104: l_date_earned DATE;
1105: l_province VARCHAR2(30);

Line 1102: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1098: ORDER BY
1099: ppf.last_name,ppf.first_name,ppf.middle_names;
1100:
1101: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1102: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1103: l_asg_id per_assignments_f.assignment_id%TYPE;
1104: l_date_earned DATE;
1105: l_province VARCHAR2(30);
1106: l_O_AutreRevenu VARCHAR2(1000);

Line 4561: FROM pay_assignment_actions paa

4557: ) is
4558:
4559: CURSOR c_get_arch_pay_actid IS
4560: SELECT to_number(substr(paa.serial_number,17,14)) payactid --archiver payroll action id
4561: FROM pay_assignment_actions paa
4562: WHERE paa.assignment_action_id = p_assact_id;
4563: l_final_xml_string VARCHAR2(32000);
4564: l_index NUMBER;
4565: l_address_line hr_locations.address_line_1%TYPE;