DBA Data[Home] [Help]

APPS.PAY_IE_PRSI dependencies on PAY_PAYROLL_ACTIONS

Line 59: ,pay_payroll_actions ppa

55: CURSOR cur_assignment_action is
56: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
57: paa.assignment_action_id),16))
58: FROM pay_assignment_actions paa
59: ,pay_payroll_actions ppa
60: WHERE paa.assignment_id=p_assignment_id
61: AND paa.payroll_action_id=ppa.payroll_action_id
62: AND ppa.action_type in ('Q','B','R','I','V')
63: AND ppa.action_status ='C'

Line 129: ,pay_payroll_actions ppa

125: ,community_flag
126: ,exemption_start_date
127: ,exemption_end_date
128: from pay_ie_prsi_details_v pipd
129: ,pay_payroll_actions ppa
130: where assignment_id = p_assignment_id
131: and ppa.payroll_action_id = p_payroll_action_id
132: and ppa.date_earned between pipd.effective_start_date and pipd.effective_end_date;
133: