APPS.PAY_US_EMP_DT_TAX_VAL dependencies on PAY_PAYROLL_ACTIONS

Line 533: ,pay_payroll_actions ppa

529: /* 11.5.10 changes performance modification. original code
530: commented out below. */
531: select 1
532: from per_assignments_f paf
533: ,pay_payroll_actions ppa
534: ,pay_assignment_actions paa
535: where paf.assignment_id = p_assignment_id
536: and ppa.payroll_id = paf.payroll_id
537: and ppa.action_type in ('E', 'Q','R')

Line 550: from PAY_PAYROLL_ACTIONS ppa

546: from PAY_ASSIGNMENT_ACTIONS paa
547: where paa.assignment_id = p_assignment_id
548: and exists(
549: select 1
550: from PAY_PAYROLL_ACTIONS ppa
551: where ppa.payroll_action_id = paa.payroll_action_id
552: and ppa.action_type in ('E','Q','R')
553: and trunc(ppa.date_earned) between p_effective_start_date
554: and p_effective_end_date );

Line 1261: ,pay_payroll_actions ppa

1257: commented out below. */
1258:
1259: select 1
1260: from per_assignments_f paf
1261: ,pay_payroll_actions ppa
1262: ,pay_assignment_actions paa
1263: ,pay_run_results prr
1264: where substr(prr.jurisdiction_code,1,2) = p_state_code
1265: and paf.assignment_id = p_assignment_id

Line 1279: from pay_payroll_actions ppa

1275: where substr(prr.jurisdiction_code,1,2) = p_state_code
1276: and paa.assignment_action_id = prr.assignment_action_id
1277: and paa.assignment_id = p_assignment_id
1278: and exists ( select null
1279: from pay_payroll_actions ppa
1280: where ppa.payroll_action_id = paa.payroll_action_id
1281: and ppa.action_type in ('E','Q','R'));
1282: */
1283: /* Cursor to check if a payroll has been run for the county. */

Line 1290: ,pay_payroll_actions ppa

1286: /* 11.5.10 changes performance modification. original code
1287: commented out below. */
1288: select 1
1289: from per_assignments_f paf
1290: ,pay_payroll_actions ppa
1291: ,pay_assignment_actions paa
1292: ,pay_run_results prr
1293: where substr(prr.jurisdiction_code,1,6) = p_state_code || '-'||
1294: p_county_code

Line 1311: from pay_payroll_actions ppa

1307: p_county_code
1308: and paa.assignment_action_id = prr.assignment_action_id
1309: and paa.assignment_id = p_assignment_id
1310: and exists ( select null
1311: from pay_payroll_actions ppa
1312: where ppa.payroll_action_id = paa.payroll_action_id
1313: and ppa.action_type in ('E','Q','R'));
1314: */
1315:

Line 1324: ,pay_payroll_actions ppa

1320: /* 11.5.10 changes performance modification. original code
1321: commented out below. */
1322: select 1
1323: from per_assignments_f paf
1324: ,pay_payroll_actions ppa
1325: ,pay_assignment_actions paa
1326: ,pay_run_results prr
1327: where prr.jurisdiction_code = p_state_code || '-'||
1328: p_county_code ||'-'||p_city_code

Line 1344: from pay_payroll_actions ppa

1340: p_county_code ||'-'||p_city_code
1341: and paa.assignment_action_id = prr.assignment_action_id
1342: and paa.assignment_id = p_assignment_id
1343: and exists ( select null
1344: from pay_payroll_actions ppa
1345: where ppa.payroll_action_id = paa.payroll_action_id
1346: and ppa.action_type in ('E','Q','R'));
1347: */
1348: