APPS.PAY_NO_PAYPROC dependencies on PAY_PAYROLL_ACTIONS

Line 40: pay_payroll_actions ppa

36: l_proc_name := l_package || 'range_code';
37: hr_utility.set_location(l_proc_name, 10);
38: p_sqlstr := 'SELECT DISTINCT person_id
39: FROM per_all_people_f ppf,
40: pay_payroll_actions ppa
41: WHERE ppa.payroll_action_id = :payroll_action_id
42: AND ppa.business_group_id = ppf.business_group_id
43: ORDER BY ppf.person_id';
44: hr_utility.set_location(l_proc_name, 20);

Line 63: -- Bug 5943355 Fix : Changing action_type in pay_payroll_actions from 'Magnetic report' to 'Magnetic transfer'.

59: IS
60: l_proc_name VARCHAR2(100) ;
61:
62:
63: -- Bug 5943355 Fix : Changing action_type in pay_payroll_actions from 'Magnetic report' to 'Magnetic transfer'.
64: -- old : appa.action_type = 'X' (Magnetic report)
65: -- new : appa.action_type = 'M' (Magnetic transfer)
66:
67: CURSOR csr_asg(p_payroll_action_id NUMBER,

Line 79: pay_payroll_actions pa2,

75: act.assignment_id,
76: ppp.pre_payment_id
77: FROM pay_assignment_actions act,
78: per_all_assignments_f asg,
79: pay_payroll_actions pa2,
80: pay_payroll_actions pa1,
81: pay_pre_payments ppp,
82: pay_org_payment_methods_f OPM,
83: per_all_people_f pap,

Line 80: pay_payroll_actions pa1,

76: ppp.pre_payment_id
77: FROM pay_assignment_actions act,
78: per_all_assignments_f asg,
79: pay_payroll_actions pa2,
80: pay_payroll_actions pa1,
81: pay_pre_payments ppp,
82: pay_org_payment_methods_f OPM,
83: per_all_people_f pap,
84: hr_soft_coding_keyflex hsk,

Line 119: pay_payroll_actions appa

115: ))
116: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
117: FROM pay_action_interlocks pai1,
118: pay_assignment_actions act2,
119: pay_payroll_actions appa
120: WHERE pai1.locked_action_id = act.assignment_action_id
121: AND act2.assignment_action_id = pai1.locking_action_id
122: AND act2.payroll_action_id = appa.payroll_action_id
123: -- AND appa.action_type = 'X'

Line 241: pay_payroll_actions ppa

237: select pop.pmeth_information1
238: from pay_org_payment_methods_f pop,
239: pay_payment_types ppt,
240: pay_org_pay_method_usages_f ppu,
241: pay_payroll_actions ppa
242:
243: where ppt.payment_type_id=pop.payment_type_id
244: and ppt.category in ('MT')
245: and ppu.payroll_id=p_payroll_id

Line 339: update pay_payroll_actions set action_type='M' where payroll_action_id=p_payroll_action_id;

335:
336: begin
337:
338:
339: update pay_payroll_actions set action_type='M' where payroll_action_id=p_payroll_action_id;
340:
341:
342: l_text1 := get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','BF99')||lpad(to_char(p_enterprise_no),11,'0')||rpad(' ',11,' ')||
343: lpad(p_seq_control,4,'0')||rpad(' ',6,' ');