APPS.HR_DIRBAL dependencies on PAY_PAYROLL_ACTIONS

Line 31: pay_payroll_actions ppa

27: SELECT
28: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
29: paa.assignment_action_id),16))
30: FROM pay_assignment_actions paa,
31: pay_payroll_actions ppa
32: WHERE
33: paa.assignment_id = p_assignment_id
34: AND ppa.payroll_action_id = paa.payroll_action_id
35: AND ppa.effective_date <= p_effective_date

Line 117: from pay_payroll_actions ppa,

113: l_balance := 0;
114:
115: select ppa.time_period_id
116: into l_time_period_id
117: from pay_payroll_actions ppa,
118: pay_assignment_actions paa
119: where paa.assignment_action_id = p_assignment_action_id
120: and ppa.payroll_action_id = paa.payroll_action_id;
121:

Line 257: pay_payroll_actions BACT,

253: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
254: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
255: from
256: per_time_periods PTP,
257: pay_payroll_actions BACT,
258: pay_assignment_actions ACT
259: where PTP.time_period_id = BACT.time_period_id
260: and ACT.assignment_action_id = c_assignment_action_id
261: and BACT.payroll_action_id = ACT.payroll_action_id;

Line 282: pay_payroll_actions BACT,

278: -1,-1,0),2)
279: ),'DD-MM-YYYY') finyear, BACT.payroll_id
280: FROM
281: per_time_periods PTP,
282: pay_payroll_actions BACT,
283: pay_assignment_actions ACT
284: WHERE PTP.time_period_id = BACT.time_period_id
285: AND ACT.assignment_action_id = c_assignment_action_id
286: AND BACT.payroll_action_id = ACT.payroll_action_id;

Line 307: pay_payroll_actions BACT,

303: -1,0,-1),2)
304: ),'DD-MM-YYYY') finyear, BACT.payroll_id
305: FROM
306: per_time_periods PTP,
307: pay_payroll_actions BACT,
308: pay_assignment_actions ACT
309: WHERE PTP.time_period_id = BACT.time_period_id
310: AND ACT.assignment_action_id = c_assignment_action_id
311: AND BACT.payroll_action_id = ACT.payroll_action_id;

Line 406: pay_payroll_actions ppa,

402: --
403: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
404: select ptp.end_date
405: from per_time_periods ptp,
406: pay_payroll_actions ppa,
407: pay_assignment_actions paa
408: WHERE
409: paa.assignment_action_id = c_assignment_action_id
410: AND paa.payroll_action_id = ppa.payroll_action_id

Line 454: FROM pay_payroll_actions ppa,

450: l_effective_date date;
451: --
452: cursor c_bal_date is
453: SELECT ppa.effective_date
454: FROM pay_payroll_actions ppa,
455: pay_assignment_actions paa
456: WHERE paa.payroll_action_id = ppa.payroll_action_id
457: AND paa.assignment_action_id = p_assignment_action_id;
458: --