[Home] [Help]
113: reversal_exists_check
114: reversal_exists_check_tax
115: to return data for only the assignment_id
116: processed in the run payroll actions.
117: Eliminate a second join to pay_action_interlocks
118: in the procedure get_prepayment_aaid, as it
119: was not needed.
120: ekim 25-Nov-2002 115.38 Changed like to = in function get_defined_balance
121: in query that gets l_defined_balance_id.
323: FUNCTION payments_balance_required(p_assignment_action_id NUMBER) RETURN boolean IS
324:
325: cursor c_prepay_action (cp_run_action_id number) is
326: select paa.assignment_action_id
327: from pay_action_interlocks pai,
328: pay_assignment_actions paa,
329: pay_payroll_actions ppa
330: where pai.locked_action_id = cp_run_action_id
331: and paa.assignment_action_id = pai.locking_action_id
340: and ppp.source_action_id = cp_assignment_action_id;
341: /*
342: CURSOR c_count_runs(cp_pre_pymt_action_id NUMBER ) IS
343: select count(pai.locked_action_id)
344: from pay_action_interlocks pai,
345: pay_pre_payments ppp,
346: pay_assignment_actions paa
347: where ppp.assignment_action_id = cp_pre_pymt_action_id
348: and nvl(ppp.source_action_id,0) <> pai.locked_action_id
353:
354:
355: CURSOR c_count_runs(cp_pre_pymt_action_id NUMBER , cp_run_type_id NUMBER) IS
356: select count(pai.locked_action_id)
357: from pay_action_interlocks pai,
358: pay_assignment_actions paa
359: where pai.locking_action_id = cp_pre_pymt_action_id
360: and pai.locked_action_id = paa.assignment_action_id
361: and nvl(paa.run_type_id,cp_run_type_id) <> cp_run_type_id
1260: cursor prepayment_aaid(param_aaid number) is
1261: select pai.locking_action_id
1262: from pay_assignment_actions paa2,
1263: pay_payroll_actions ppa2,
1264: pay_action_interlocks pai,
1265: pay_assignment_actions paa,
1266: pay_payroll_actions ppa
1267: where pai.locked_Action_id = param_aaid
1268: and pai.locking_action_id = pai.locking_action_id
1273: and paa2.payroll_Action_id = ppa2.payroll_Action_id
1274: and ppa2.action_type in ('R','Q')
1275: /*
1276: and exists ( select locked_action_id,locking_action_id
1277: from pay_action_interlocks paie,
1278: pay_assignment_Actions paae,
1279: pay_payroll_Actions ppae
1280: where paie.locked_action_id = pai2.locked_action_id
1281: and paie.locking_action_id = paae.assignment_action_id
1323: cp_run_assignment_id in number) is
1324: select pai.locked_action_id
1325: from pay_payroll_actions ppa,
1326: pay_assignment_actions paa,
1327: pay_action_interlocks pai
1328: where pai.locking_action_id = cp_pre_pay_action_id
1329: and pai.locked_action_id = paa.assignment_action_id
1330: and paa.assignment_id = cp_run_assignment_id
1331: and paa.payroll_action_id = ppa.payroll_action_id
1430: cp_run_assignment_id in number) is
1431: select pai.locked_action_id
1432: from pay_payroll_actions ppa,
1433: pay_assignment_actions paa,
1434: pay_action_interlocks pai
1435: where pai.locking_action_id = cp_pre_pay_action_id
1436: and pai.locked_action_id = paa.assignment_action_id
1437: and paa.assignment_id = cp_run_assignment_id
1438: and paa.payroll_action_id = ppa.payroll_action_id
1531: CURSOR C_GET_MASTER_AAID (cp_prepay_action_id in number,
1532: cp_assignment_id in number) is
1533: select max(paa.assignment_action_id)
1534: from pay_assignment_actions paa, -- assignment_action for master payroll run
1535: pay_action_interlocks pai
1536: where pai.locking_action_id = cp_prepay_action_id
1537: and pai.locked_action_id = paa.assignment_action_id
1538: and paa.assignment_id = cp_assignment_id
1539: and paa.source_action_id is null -- master assignment_action
1641: IF l_sep_check <> 'Y' THEN
1642:
1643: select paa.assignment_action_id
1644: into l_pre_pay_aaid
1645: from pay_action_interlocks pai,
1646: pay_assignment_actions paa,
1647: pay_payroll_actions ppa
1648: where pai.locked_action_id = l_assignment_action_id
1649: and paa.assignment_action_id = pai.locking_action_id
1799: CURSOR C_GET_MASTER_AAID (cp_prepay_action_id in number,
1800: cp_assignment_id in number) is
1801: select max(paa.assignment_action_id)
1802: from pay_assignment_actions paa, -- assignment_action for master payroll run
1803: pay_action_interlocks pai
1804: where pai.locking_action_id = cp_prepay_action_id
1805: and pai.locked_action_id = paa.assignment_action_id
1806: and paa.assignment_id = cp_assignment_id
1807: and paa.source_action_id is null -- master assignment_action
1898: IF l_sep_check <> 'Y' THEN
1899:
1900: select paa.assignment_action_id
1901: into l_pre_pay_aaid
1902: from pay_action_interlocks pai,
1903: pay_assignment_actions paa,
1904: pay_payroll_actions ppa
1905: where pai.locked_action_id = l_assignment_action_id
1906: and paa.assignment_action_id = pai.locking_action_id