APPS.PAY_US_EMP_DT_TAX_VAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 534: ,pay_assignment_actions paa

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')
538: and ppa.payroll_action_id = paa.payroll_action_id

Line 546: from PAY_ASSIGNMENT_ACTIONS paa

542:
543: /*
544:
545: select 1
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

Line 1262: ,pay_assignment_actions paa

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
1266: and ppa.payroll_id = paf.payroll_id

Line 1274: pay_assignment_actions paa

1270: and paa.assignment_action_id = prr.assignment_action_id ;
1271:
1272: /* select 1
1273: from pay_run_results prr,
1274: pay_assignment_actions paa
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

Line 1291: ,pay_assignment_actions paa

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
1295: and paf.assignment_id = p_assignment_id

Line 1305: pay_assignment_actions paa

1301:
1302: /*
1303: select 1
1304: from pay_run_results prr,
1305: pay_assignment_actions paa
1306: where substr(prr.jurisdiction_code,1,6) = p_state_code || '-'||
1307: p_county_code
1308: and paa.assignment_action_id = prr.assignment_action_id
1309: and paa.assignment_id = p_assignment_id

Line 1325: ,pay_assignment_actions paa

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
1329: and paf.assignment_id = p_assignment_id

Line 1338: pay_assignment_actions paa

1334: and paa.assignment_action_id = prr.assignment_action_id ;
1335:
1336: /* select 1
1337: from pay_run_results prr,
1338: pay_assignment_actions paa
1339: where prr.jurisdiction_code = p_state_code || '-'||
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