APPS.HR_JPDRB dependencies on PAY_ASSIGNMENT_ACTIONS

Line 47: pay_assignment_actions paa

43: cursor get_latest_id_for_effect
44: is
45: SELECT TO_NUMBER(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
46: FROM pay_payroll_actions ppa,
47: pay_assignment_actions paa
48: WHERE paa.assignment_id = p_assignment_id
49: AND ppa.payroll_action_id = paa.payroll_action_id
50: AND ppa.effective_date <= p_effective_date
51: AND ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 57: pay_assignment_actions ASSACT

53: cursor get_latest_id_for_earned
54: is
55: SELECT TO_NUMBER(substr(max(lpad(ASSACT.action_sequence,15,'0')||ASSACT.assignment_action_id),16))
56: FROM pay_payroll_actions PACT,
57: pay_assignment_actions ASSACT
58: WHERE ASSACT.assignment_id = p_assignment_id
59: AND PACT.payroll_action_id = ASSACT.payroll_action_id
60: AND PACT.date_earned <= p_effective_date
61: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 181: pay_assignment_actions ASSACT

177: is
178: SELECT PACT.business_group_id,
179: PACT.date_earned
180: FROM pay_payroll_actions PACT,
181: pay_assignment_actions ASSACT
182: WHERE ASSACT.assignment_action_id = p_assignment_action_id
183: AND PACT.payroll_action_id = ASSACT.payroll_action_id;
184: --
185: BEGIN

Line 294: pay_assignment_actions paa

290: is
291: SELECT ptp.end_date
292: FROM per_time_periods ptp,
293: pay_payroll_actions ppa,
294: pay_assignment_actions paa
295: WHERE paa.assignment_action_id = c_assignment_action_id
296: AND ppa.payroll_action_id = paa.payroll_action_id
297: AND ptp.time_period_id = ppa.time_period_id;
298: --

Line 322: pay_assignment_actions paa

318: cursor c_bal_date
319: is
320: SELECT ppa.effective_date
321: FROM pay_payroll_actions ppa,
322: pay_assignment_actions paa
323: WHERE paa.assignment_action_id = p_assignment_action_id
324: AND paa.payroll_action_id = ppa.payroll_action_id;
325: --
326: BEGIN