APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_ASSIGNMENT_ACTIONS

Line 235: pay_assignment_actions act,

231: --
232: CURSOR c_chk_archive IS
233: SELECT 'Y' found_flag
234: FROM pay_action_information pai,
235: pay_assignment_actions act,
236: pay_payroll_actions ppa
237: WHERE ppa.report_type = 'P46_CAR_EDI'
238: AND ppa.report_qualifier='GB'
239: AND ppa.report_category ='EDI'

Line 288: pay_assignment_actions act,

284: --
285: CURSOR c_chk_archive IS
286: SELECT 'Y' found_flag
287: FROM pay_action_information pai,
288: pay_assignment_actions act,
289: pay_payroll_actions ppa
290: WHERE ppa.report_type IN ('P46_CAR_EDI_V2','P46_CAR_EDI')
291: AND ppa.report_qualifier='GB'
292: AND ppa.report_category ='EDI'

Line 529: l_actid pay_assignment_actions.assignment_action_id%TYPE;

525: endperson IN NUMBER,
526: chunk IN NUMBER) IS
527: --
528: l_proc CONSTANT VARCHAR2(35):= g_package||'create_asg_act';
529: l_actid pay_assignment_actions.assignment_action_id%TYPE;
530: l_ovn pay_action_information.object_version_number%TYPE;
531: --
532: --
533: CURSOR c_param_values IS

Line 954: SELECT pay_assignment_actions_s.nextval

950: --
951: -- If flag is set then create action
952: IF l_create_assact_flag = 'Y' THEN
953: --
954: SELECT pay_assignment_actions_s.nextval
955: INTO l_actid
956: FROM dual;
957:
958: hr_utility.set_location(l_proc, 270);

Line 994: l_actid pay_assignment_actions.assignment_action_id%TYPE;

990: endperson IN NUMBER,
991: chunk IN NUMBER) IS
992: --
993: l_proc CONSTANT VARCHAR2(35):= g_package||'create_asg_act';
994: l_actid pay_assignment_actions.assignment_action_id%TYPE;
995: l_ovn pay_action_information.object_version_number%TYPE;
996: --
997: --
998: CURSOR c_param_values IS

Line 1419: SELECT pay_assignment_actions_s.nextval

1415: --
1416: -- If flag is set then create action
1417: IF l_create_assact_flag = 'Y' THEN
1418: --
1419: SELECT pay_assignment_actions_s.nextval
1420: INTO l_actid
1421: FROM dual;
1422:
1423: hr_utility.set_location(l_proc, 270);

Line 1863: pay_assignment_actions act

1859: max(asg.effective_end_date) asg_max_end_date
1860: FROM hr_soft_coding_keyflex flex,
1861: per_all_assignments_f asg,
1862: Pay_payrolls_f ppf,
1863: pay_assignment_actions act
1864: WHERE act.assignment_action_id = p_assactid
1865: AND act.assignment_id = asg.assignment_id
1866: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)
1867: AND asg.payroll_id = ppf.payroll_id

Line 2300: pay_assignment_actions act

2296: max(asg.effective_end_date) asg_max_end_date
2297: FROM hr_soft_coding_keyflex flex,
2298: per_all_assignments_f asg,
2299: Pay_payrolls_f ppf,
2300: pay_assignment_actions act
2301: WHERE act.assignment_action_id = p_assactid
2302: AND act.assignment_id = asg.assignment_id
2303: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)
2304: AND asg.payroll_id = ppf.payroll_id