APPS.PAY_ZA_PAYROLL_ACTION_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 134: pay_payroll_actions ppa,

130: rpaa.payroll_action_id,
131: rpaa.assignment_action_id,
132: paa.assignment_action_id
133: from pay_assignment_actions paa,
134: pay_payroll_actions ppa,
135: pay_assignment_actions rpaa,
136: pay_payroll_actions rppa
137: where paa.payroll_action_id = ppa.payroll_action_id
138: and rppa.payroll_action_id = rpaa.payroll_action_id

Line 136: pay_payroll_actions rppa

132: paa.assignment_action_id
133: from pay_assignment_actions paa,
134: pay_payroll_actions ppa,
135: pay_assignment_actions rpaa,
136: pay_payroll_actions rppa
137: where paa.payroll_action_id = ppa.payroll_action_id
138: and rppa.payroll_action_id = rpaa.payroll_action_id
139: and paa.assignment_id = rpaa.assignment_id
140: and paa.assignment_action_id =

Line 143: from pay_payroll_actions pa,

139: and paa.assignment_id = rpaa.assignment_id
140: and paa.assignment_action_id =
141: (select
142: to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
143: from pay_payroll_actions pa,
144: pay_assignment_actions aa
145: where pa.action_type in ('U','P')
146: and aa.action_status IN ('C','S') --10376999
147: and pa.payroll_action_id = aa.payroll_action_id

Line 165: pay_payroll_actions ppa

161: SELECT /*+ USE_NL(paa, ppa) */
162: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
163: paa.assignment_action_id),16))
164: FROM pay_assignment_actions paa,
165: pay_payroll_actions ppa
166: WHERE
167: paa.assignment_id = p_assignment_id
168: AND ppa.payroll_action_id = paa.payroll_action_id
169: AND (paa.source_action_id is not null

Line 177: from pay_payroll_actions ppa,

173:
174: cursor csr_formula_3(p_assig_act_id NUMBER) is
175: select to_char(nvl(ppa.date_earned,ppa.effective_date),'YYYY/MM/DD'),
176: paa.payroll_action_id
177: from pay_payroll_actions ppa,
178: pay_assignment_actions paa
179: where paa.assignment_action_id = p_assig_act_id
180: and ppa.payroll_action_id = paa.payroll_action_id;
181:

Line 185: pay_payroll_actions pact

181:
182: cursor csr_formula_4(p_assig_act_id NUMBER) is
183: select pact.action_type
184: from pay_assignment_actions assact,
185: pay_payroll_actions pact
186: where assact.assignment_action_id = p_assignment_action_id
187: and pact.payroll_action_id = assact.payroll_action_id;
188:
189: cursor csr_formula_5(p_assig_act_id NUMBER) is

Line 259: pay_payroll_actions pact

255: cursor csr_formula is
256: -- find what type of action this is
257: select pact.action_type , assact.assignment_id
258: from pay_assignment_actions assact,
259: pay_payroll_actions pact
260: where assact.assignment_action_id = p_assignment_action_id
261: and pact.payroll_action_id = assact.payroll_action_id
262: ;
263: cursor csr_formula_2 is

Line 276: pay_payroll_actions pact,

272: cursor csr_formula_3 is
273: -- for run action check if its been prepaid
274: select assact.assignment_action_id
275: from pay_assignment_actions assact,
276: pay_payroll_actions pact,
277: pay_action_interlocks loc
278: where loc.locked_action_id = p_assignment_action_id
279: and assact.assignment_action_id = loc.locking_action_id
280: and pact.payroll_action_id = assact.payroll_action_id

Line 289: pay_payroll_actions pact

285: -- now find the date earned and payroll action of the run action
286: select pact.payroll_action_id,
287: to_char(nvl(pact.date_earned,pact.effective_date),'YYYY/MM/DD')
288: from pay_assignment_actions assact,
289: pay_payroll_actions pact
290: where assact.assignment_action_id = p_run_assignment_action_id
291: and pact.payroll_action_id = assact.payroll_action_id
292: ;
293: --