DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_RUN_TYPES_F

Line 336: from pay_run_types_f prt

332:
333:
334: cursor c_run_type_id is
335: select prt.run_type_id
336: from pay_run_types_f prt
337: where prt.shortname = 'SEPCHECK'
338: and prt.legislation_code = 'US';
339:
340: l_count_runs NUMBER;

Line 1214: from pay_run_types_f prt

1210: p_business_group_id number DEFAULT NULL)
1211: RETURN number is
1212: cursor c_run_type_id is
1213: select prt.run_type_id
1214: from pay_run_types_f prt
1215: where prt.shortname = 'SEPCHECK'
1216: and prt.legislation_code = 'US';
1217:
1218: cursor c_run_action_info

Line 1321: from pay_run_types_f prt

1317: RETURN number is
1318:
1319: cursor c_run_type_id is
1320: select prt.run_type_id
1321: from pay_run_types_f prt
1322: where prt.shortname = 'SEPCHECK'
1323: and prt.legislation_code = 'US';
1324:
1325: cursor c_run_action_info

Line 1519: ,pay_run_types_f prt

1515: paa.assignment_id
1516: INTO l_sep_check,
1517: l_assignment_id
1518: FROM pay_assignment_actions paa
1519: ,pay_run_types_f prt
1520: WHERE paa.assignment_action_id = l_assignment_action_id
1521: AND prt.run_type_id = paa.run_type_id
1522: AND prt.legislation_code = 'US';
1523:

Line 1706: ,pay_run_types_f prt

1702: paa.assignment_id
1703: INTO l_sep_check,
1704: l_assignment_id
1705: FROM pay_assignment_actions paa
1706: ,pay_run_types_f prt
1707: WHERE paa.assignment_action_id = l_assignment_action_id
1708: AND prt.run_type_id = paa.run_type_id
1709: AND prt.legislation_code = 'US';
1710: