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 80: pay_payroll_actions pa2,

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

Line 81: pay_payroll_actions pa1,

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

Line 127: pay_payroll_actions appa

123: ))
124: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
125: FROM pay_action_interlocks pai1,
126: pay_assignment_actions act2,
127: pay_payroll_actions appa
128: WHERE pai1.locked_action_id = act.assignment_action_id
129: AND act2.assignment_action_id = pai1.locking_action_id
130: AND act2.payroll_action_id = appa.payroll_action_id
131: -- AND appa.action_type = 'X'

Line 257: pay_payroll_actions ppa

253: select pop.pmeth_information1
254: from pay_org_payment_methods_f pop,
255: pay_payment_types ppt,
256: pay_org_pay_method_usages_f ppu,
257: pay_payroll_actions ppa
258:
259: where ppt.payment_type_id=pop.payment_type_id
260: and ppt.category in ('MT')
261: and ppu.payroll_id=p_payroll_id

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

357:
358: begin
359:
360:
361: update pay_payroll_actions set action_type='M' where payroll_action_id=p_payroll_action_id;
362:
363:
364: l_text1 := get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','BF99')||lpad(to_char(p_enterprise_no),11,'0')||rpad(' ',11,' ')||
365: lpad(p_seq_control,4,'0')||rpad(' ',6,' ');