[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.
292: FUNCTION payments_balance_required(p_assignment_action_id NUMBER) RETURN boolean IS
293:
294: cursor c_prepay_action (cp_run_action_id number) is
295: select paa.assignment_action_id
296: from pay_action_interlocks pai,
297: pay_assignment_actions paa,
298: pay_payroll_actions ppa
299: where pai.locked_action_id = cp_run_action_id
300: and paa.assignment_action_id = pai.locking_action_id
309: and ppp.source_action_id = cp_assignment_action_id;
310: /*
311: CURSOR c_count_runs(cp_pre_pymt_action_id NUMBER ) IS
312: select count(pai.locked_action_id)
313: from pay_action_interlocks pai,
314: pay_pre_payments ppp,
315: pay_assignment_actions paa
316: where ppp.assignment_action_id = cp_pre_pymt_action_id
317: and nvl(ppp.source_action_id,0) <> pai.locked_action_id
322:
323:
324: CURSOR c_count_runs(cp_pre_pymt_action_id NUMBER , cp_run_type_id NUMBER) IS
325: select count(pai.locked_action_id)
326: from pay_action_interlocks pai,
327: pay_assignment_actions paa
328: where pai.locking_action_id = cp_pre_pymt_action_id
329: and pai.locked_action_id = paa.assignment_action_id
330: and nvl(paa.run_type_id,cp_run_type_id) <> cp_run_type_id
1164: cursor prepayment_aaid(param_aaid number) is
1165: select pai.locking_action_id
1166: from pay_assignment_actions paa2,
1167: pay_payroll_actions ppa2,
1168: pay_action_interlocks pai,
1169: pay_assignment_actions paa,
1170: pay_payroll_actions ppa
1171: where pai.locked_Action_id = param_aaid
1172: and pai.locking_action_id = pai.locking_action_id
1177: and paa2.payroll_Action_id = ppa2.payroll_Action_id
1178: and ppa2.action_type in ('R','Q')
1179: /*
1180: and exists ( select locked_action_id,locking_action_id
1181: from pay_action_interlocks paie,
1182: pay_assignment_Actions paae,
1183: pay_payroll_Actions ppae
1184: where paie.locked_action_id = pai2.locked_action_id
1185: and paie.locking_action_id = paae.assignment_action_id
1227: cp_run_assignment_id in number) is
1228: select pai.locked_action_id
1229: from pay_payroll_actions ppa,
1230: pay_assignment_actions paa,
1231: pay_action_interlocks pai
1232: where pai.locking_action_id = cp_pre_pay_action_id
1233: and pai.locked_action_id = paa.assignment_action_id
1234: and paa.assignment_id = cp_run_assignment_id
1235: and paa.payroll_action_id = ppa.payroll_action_id
1334: cp_run_assignment_id in number) is
1335: select pai.locked_action_id
1336: from pay_payroll_actions ppa,
1337: pay_assignment_actions paa,
1338: pay_action_interlocks pai
1339: where pai.locking_action_id = cp_pre_pay_action_id
1340: and pai.locked_action_id = paa.assignment_action_id
1341: and paa.assignment_id = cp_run_assignment_id
1342: and paa.payroll_action_id = ppa.payroll_action_id
1431: CURSOR C_GET_MASTER_AAID (cp_prepay_action_id in number,
1432: cp_assignment_id in number) is
1433: select max(paa.assignment_action_id)
1434: from pay_assignment_actions paa, -- assignment_action for master payroll run
1435: pay_action_interlocks pai
1436: where pai.locking_action_id = cp_prepay_action_id
1437: and pai.locked_action_id = paa.assignment_action_id
1438: and paa.assignment_id = cp_assignment_id
1439: and paa.source_action_id is null -- master assignment_action
1530: IF l_sep_check <> 'Y' THEN
1531:
1532: select paa.assignment_action_id
1533: into l_pre_pay_aaid
1534: from pay_action_interlocks pai,
1535: pay_assignment_actions paa,
1536: pay_payroll_actions ppa
1537: where pai.locked_action_id = l_assignment_action_id
1538: and paa.assignment_action_id = pai.locking_action_id
1618: CURSOR C_GET_MASTER_AAID (cp_prepay_action_id in number,
1619: cp_assignment_id in number) is
1620: select max(paa.assignment_action_id)
1621: from pay_assignment_actions paa, -- assignment_action for master payroll run
1622: pay_action_interlocks pai
1623: where pai.locking_action_id = cp_prepay_action_id
1624: and pai.locked_action_id = paa.assignment_action_id
1625: and paa.assignment_id = cp_assignment_id
1626: and paa.source_action_id is null -- master assignment_action
1717: IF l_sep_check <> 'Y' THEN
1718:
1719: select paa.assignment_action_id
1720: into l_pre_pay_aaid
1721: from pay_action_interlocks pai,
1722: pay_assignment_actions paa,
1723: pay_payroll_actions ppa
1724: where pai.locked_action_id = l_assignment_action_id
1725: and paa.assignment_action_id = pai.locking_action_id