DBA Data[Home] [Help]

APPS.PAY_US_SOE_UTILS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 42: pay_assignment_actions paa

38: cursor cur_get_date is
39: select
40: nvl(ppa.date_earned, ppa.effective_date)
41: from pay_payroll_actions ppa,
42: pay_assignment_actions paa
43: where paa.assignment_action_id = p_assignment_action_id
44: and ppa.payroll_action_id = paa.payroll_action_id;
45:
46: cursor cur_actual_termination_date is

Line 51: pay_assignment_actions paa,

47: select
48: pos.actual_termination_date
49: from per_periods_of_service pos,
50: per_assignments_f paf,
51: pay_assignment_actions paa,
52: pay_payroll_actions ppa
53: where paf.assignment_id = paa.assignment_id
54: and ppa.payroll_action_id = paa.payroll_action_id
55: and paa.assignment_action_id = p_assignment_action_id

Line 70: pay_assignment_actions paa

66: pay_input_values_f piv,
67: per_pay_bases ppb,
68: per_assignments_f paf,
69: pay_payroll_actions ppa,
70: pay_assignment_actions paa
71: where
72: least(nvl(ppa.date_earned, ppa.effective_date),
73: nvl(l_term_date, nvl(ppa.date_earned, ppa.effective_date)
74: )