DBA Data[Home] [Help]

APPS.PAY_US_SOE_UTILS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 41: from pay_payroll_actions ppa,

37:
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:

Line 52: pay_payroll_actions ppa

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
56: and l_date between paf.effective_start_date

Line 69: pay_payroll_actions ppa,

65: pay_element_entry_values_f peev,
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)