eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_EMP_DT_TAX_VAL dependencies on PAY_RUN_RESULTS

Line 1263: ,pay_run_results prr

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
1267: and ppa.action_type in ('E', 'Q','R')

Line 1273: from pay_run_results prr,

1269: and paa.assignment_id = paf.assignment_id
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

Line 1292: ,pay_run_results prr

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

Line 1304: from pay_run_results prr,

1300: and paa.assignment_action_id = prr.assignment_action_id ;
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

Line 1326: ,pay_run_results prr

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

Line 1337: from pay_run_results prr,

1333: and paa.assignment_id = paf.assignment_id
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