APPS.PAY_NZ_EFT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 68: ,c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

64: AND c_effective_date BETWEEN ppmf.effective_start_date AND ppmf.effective_end_date;
65:
66: CURSOR get_legal_employer_info
67: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
68: ,c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
69: IS
70: SELECT hou.name
71: FROM pay_assignment_actions paa,
72: hr_organization_units hou

Line 71: FROM pay_assignment_actions paa,

67: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
68: ,c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
69: IS
70: SELECT hou.name
71: FROM pay_assignment_actions paa,
72: hr_organization_units hou
73: WHERE paa.payroll_action_id = c_payroll_action_id
74: AND paa.assignment_action_id = c_assignment_action_id
75: AND to_char(hou.organization_id) = paa.tax_unit_id;

Line 82: FROM pay_assignment_actions paa,

78:
79: CURSOR get_batch_due_date(c_pre_payment_id pay_pre_payments.pre_payment_id%TYPE)
80: IS
81: SELECT to_char(ptp.default_dd_date,'YYYYMMDD')
82: FROM pay_assignment_actions paa,
83: pay_pre_payments ppp,
84: pay_payroll_actions ppa,
85: pay_action_interlocks pai,
86: per_time_periods ptp