APPS.PAY_US_PAYMENT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 40: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE

36: ***************************************************************************/
37: FUNCTION get_trx_date (
38: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
39: p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
40: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
41: DEFAULT NULL,
42: p_payroll_id pay_payroll_actions.payroll_id%TYPE
43: DEFAULT NULL,
44: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE

Line 110: pay_assignment_actions paa_chk,

106: )
107: IS
108: SELECT NVL (ppa_chk.overriding_dd_date, ppa_pre.effective_date)
109: FROM pay_payroll_actions ppa_chk,
110: pay_assignment_actions paa_chk,
111: pay_payroll_actions ppa_pre,
112: pay_assignment_actions paa_pre,
113: pay_action_interlocks pai,
114: pay_pre_payments ppp

Line 112: pay_assignment_actions paa_pre,

108: SELECT NVL (ppa_chk.overriding_dd_date, ppa_pre.effective_date)
109: FROM pay_payroll_actions ppa_chk,
110: pay_assignment_actions paa_chk,
111: pay_payroll_actions ppa_pre,
112: pay_assignment_actions paa_pre,
113: pay_action_interlocks pai,
114: pay_pre_payments ppp
115: WHERE ppa_chk.payroll_action_id = cp_payroll_action_id
116: AND ppa_chk.business_group_id = cp_business_group_id

Line 149: pay_assignment_actions paa,

145: CURSOR c_get_pymt_date_with_prepay_id (cp_pre_payment_id IN NUMBER)
146: IS
147: SELECT ppa.effective_date
148: FROM pay_pre_payments ppp,
149: pay_assignment_actions paa,
150: pay_payroll_actions ppa
151: WHERE ppp.pre_payment_id = cp_pre_payment_id
152: AND ppp.assignment_action_id = paa.assignment_action_id
153: AND paa.payroll_action_id = ppa.payroll_action_id