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;
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
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
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:
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: