DBA Data[Home] [Help]

APPS.PAY_CNT_BUS dependencies on PAY_PAYROLL_ACTIONS

Line 1143: from pay_payroll_actions ppa,

1139: and paf.assignment_id = paa.assignment_id
1140: and prr.assignment_action_id = paa.assignment_action_id
1141: and substr(prr.jurisdiction_code,1,6)=p_state_code||'-'||p_county_code
1142: and exists (select null
1143: from pay_payroll_actions ppa,
1144: pay_payrolls_f ppf --Bug 3419781
1145: where ppa.payroll_action_id = paa.payroll_action_id
1146: and ppa.action_type in ('Q','R')
1147: and ppa.date_earned > p_csr_tmp_date