DBA Data[Home] [Help]

APPS.PAY_CTY_BUS dependencies on PAY_PAYROLL_ACTIONS

Line 1130: from pay_payroll_actions ppa,

1126: and prr.assignment_action_id = paa.assignment_action_id
1127: and prr.jurisdiction_code =
1128: p_state_code||'-'||p_county_code||'-'||p_city_code
1129: and exists (select null
1130: from pay_payroll_actions ppa,
1131: pay_payrolls_f ppf -- Bug 3419786
1132: where ppa.payroll_action_id = paa.payroll_action_id
1133: and ppa.action_type in ('Q','R')
1134: and ppa.date_earned > p_csr_tmp_date