APPS.PAY_CORE_PAYSLIP_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 19: FROM pay_payroll_actions

15: INSTR(legislative_parameters,' ',
16: INSTR(legislative_parameters,p_token))
17: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
18: business_group_id
19: FROM pay_payroll_actions
20: WHERE payroll_action_id = p_pact_id;
21:
22: l_business_group_id VARCHAR2(20);
23: l_token_value VARCHAR2(50);

Line 82: pay_payroll_actions ppa

78: hr_utility.set_location('Entering ' || l_proc,10);
79:
80: sqlstr := 'SELECT DISTINCT person_id
81: FROM per_people_f ppf,
82: pay_payroll_actions ppa
83: WHERE ppa.payroll_action_id = :payroll_action_id
84: AND ppa.business_group_id +0 = ppf.business_group_id
85: ORDER BY ppf.person_id';
86:

Line 115: FROM pay_payroll_actions ppa,

111: p_report_qualifier VARCHAR2) IS
112: SELECT act.assignment_id assignment_id,
113: act.assignment_action_id run_action_id,
114: act1.assignment_action_id prepaid_action_id
115: FROM pay_payroll_actions ppa,
116: pay_payroll_actions appa,
117: pay_payroll_actions appa2,
118: pay_assignment_actions act,
119: pay_assignment_actions act1,

Line 116: pay_payroll_actions appa,

112: SELECT act.assignment_id assignment_id,
113: act.assignment_action_id run_action_id,
114: act1.assignment_action_id prepaid_action_id
115: FROM pay_payroll_actions ppa,
116: pay_payroll_actions appa,
117: pay_payroll_actions appa2,
118: pay_assignment_actions act,
119: pay_assignment_actions act1,
120: pay_action_interlocks pai,

Line 117: pay_payroll_actions appa2,

113: act.assignment_action_id run_action_id,
114: act1.assignment_action_id prepaid_action_id
115: FROM pay_payroll_actions ppa,
116: pay_payroll_actions appa,
117: pay_payroll_actions appa2,
118: pay_assignment_actions act,
119: pay_assignment_actions act1,
120: pay_action_interlocks pai,
121: per_all_assignments_f as1

Line 144: pay_payroll_actions appa3

140: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
141: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
142: FROM pay_action_interlocks pai1,
143: pay_assignment_actions act2,
144: pay_payroll_actions appa3
145: WHERE pai1.locked_action_id = act.assignment_action_id
146: AND act2.assignment_action_id = pai1.locking_action_id
147: AND act2.payroll_action_id = appa3.payroll_action_id
148: AND appa3.action_type = 'X'

Line 246: l_run_type_id pay_payroll_actions.run_type_id%type;

242: p_assignment_action_id in number,
243: p_effective_date in date)
244: return number
245: is
246: l_run_type_id pay_payroll_actions.run_type_id%type;
247: l_act_seq pay_assignment_actions.action_sequence%type;
248: begin
249: --
250: select run_type_id

Line 252: from pay_payroll_actions

248: begin
249: --
250: select run_type_id
251: into l_run_type_id
252: from pay_payroll_actions
253: where payroll_action_id = p_payroll_action_id;
254: --
255: /* If the run type id is null then run
256: types are not being used

Line 306: pay_payroll_actions paa,

302: paa.date_earned date_earned,
303: paa.time_period_id time_period_id
304: FROM pay_action_interlocks pre,
305: pay_action_interlocks pay,
306: pay_payroll_actions paa,
307: pay_payroll_actions ppaa,
308: pay_assignment_actions assact,
309: pay_assignment_actions passact
310: WHERE pre.locked_action_id = pay.locking_action_id

Line 307: pay_payroll_actions ppaa,

303: paa.time_period_id time_period_id
304: FROM pay_action_interlocks pre,
305: pay_action_interlocks pay,
306: pay_payroll_actions paa,
307: pay_payroll_actions ppaa,
308: pay_assignment_actions assact,
309: pay_assignment_actions passact
310: WHERE pre.locked_action_id = pay.locking_action_id
311: AND pre.locking_action_id = p_locking_action_id

Line 365: pay_payroll_actions ppa

361: UNION
362: SELECT paa.assignment_action_id np_assignment_action_id,
363: 'N'
364: FROM pay_assignment_actions paa,
365: pay_payroll_actions ppa
366: WHERE paa.assignment_action_id = p_assignment_action_id
367: AND ppa.payroll_action_id = p_payroll_action_id
368: AND ppa.payroll_action_id = paa.payroll_action_id
369: AND ppa.run_type_id is null