[Home] [Help]
346: (p_assignment_id in number
347: ,p_effective_date in date
348: ) is
349: select count(0)
350: from pay_personal_payment_methods_f ppm
351: , pay_org_payment_methods_f opm
352: where ppm.assignment_id = p_assignment_id
353: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
354: and p_effective_date between
434: , ppm.attribute18
435: , ppm.attribute19
436: , ppm.attribute20
437: , ppm.run_type_id
438: from pay_personal_payment_methods_f ppm
439: , pay_org_payment_methods_f opm
440: , pay_payment_types ppt
441: , pay_defined_balances pdb
442: , pay_balance_types pbt
475: cursor csr_dt_row_count
476: (p_personal_payment_method_id in number
477: ) is
478: select count(0)
479: from pay_personal_payment_methods_f ppm
480: where ppm.personal_payment_method_id = p_personal_payment_method_id
481: ;
482: l_effective_date date;
483: l_ppm pay_ppmv4_utils_ss.t_ppmv4;
622: -- delete is done on that row.
623: --
624: select ppm.object_version_number
625: into l_ppm.delete_ovn
626: from pay_personal_payment_methods_f ppm
627: where ppm.personal_payment_method_id =
628: l_ppm.personal_payment_method_id
629: and ppm.effective_end_date = (l_effective_date-1);
630: else
1313: (p_assignment_id in number
1314: ,p_effective_date in date
1315: ) is
1316: select null
1317: from pay_personal_payment_methods_f ppm
1318: where ppm.assignment_id = p_assignment_id
1319: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1320: and ppm.effective_start_date > p_effective_date
1321: ;
1327: (p_assignment_id in number
1328: ,p_effective_date in date
1329: ) is
1330: select null
1331: from pay_personal_payment_methods_f ppm
1332: where ppm.assignment_id = p_assignment_id
1333: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1334: and p_effective_date between
1335: ppm.effective_start_date and ppm.effective_end_date
1344: (p_assignment_id in number
1345: ,p_effective_date in date
1346: ) is
1347: select null
1348: from pay_personal_payment_methods_f ppm
1349: , pay_org_payment_methods_f opm
1350: where ppm.assignment_id = p_assignment_id
1351: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1352: and p_effective_date between
1356: opm.effective_start_date and opm.effective_end_date
1357: and opm.defined_balance_id is not null
1358: and ( (p_run_type_id is not null) or (ppm.priority <
1359: (select max(priority)
1360: from pay_personal_payment_methods_f ppm1
1361: where ppm1.assignment_id = p_assignment_id
1362: and nvl(ppm1.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1363: and p_effective_date between
1364: ppm1.effective_start_date and ppm1.effective_end_date)))
2368:
2369: -- Curosor to get the actual percentage/amount of the ppm.
2370: cursor fetch_org_values is
2371: select ppm.AMOUNT, ppm.PERCENTAGE
2372: from pay_personal_payment_methods_f ppm,
2373: pay_pss_transaction_steps pps
2374: where pps.transaction_step_id = p_transaction_step_id
2375: and pps.PERSONAL_PAYMENT_METHOD_ID = ppm.PERSONAL_PAYMENT_METHOD_ID
2376: and pps.ASSIGNMENT_ID= ppm.ASSIGNMENT_ID
2409: if l_amount_type = C_REMAINING_PAY and
2410: p_logical_priority < l_logical_priority then
2411: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'REMAINING_PAY', 5);
2412:
2413: -- fetch the oriiginal values from the pay_personal_payment_methods_f table
2414: open fetch_org_values;
2415: fetch fetch_org_values
2416: into l_org_amt, l_org_percent;
2417:
3183: select ppm.personal_payment_method_id ppmid
3184: , ppm.object_version_number ovn
3185: , ppm.effective_start_date esd
3186: , ppm.priority priority
3187: from pay_personal_payment_methods_f ppm
3188: , pay_org_payment_methods_f opm
3189: where ppm.assignment_id = p_assignment_id
3190: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
3191: and p_effective_date