APPS.PAY_PPMV4_SS dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 350: from pay_personal_payment_methods_f ppm

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:

Line 504: from pay_personal_payment_methods_f ppm

500: ,ppm.ppm_information27
501: ,ppm.ppm_information28
502: ,ppm.ppm_information29
503: ,ppm.ppm_information30
504: from pay_personal_payment_methods_f ppm
505: , pay_org_payment_methods_f opm
506: , pay_payment_types ppt
507: , pay_defined_balances pdb
508: , pay_balance_types pbt

Line 548: from pay_personal_payment_methods_f ppm

544: cursor csr_dt_row_count
545: (p_personal_payment_method_id in number
546: ) is
547: select count(0)
548: from pay_personal_payment_methods_f ppm
549: where ppm.personal_payment_method_id = p_personal_payment_method_id
550: ;
551: l_effective_date date;
552: l_ppm pay_ppmv4_utils_ss.t_ppmv4;

Line 695: from pay_personal_payment_methods_f ppm

691: -- delete is done on that row.
692: --
693: select ppm.object_version_number
694: into l_ppm.delete_ovn
695: from pay_personal_payment_methods_f ppm
696: where ppm.personal_payment_method_id =
697: l_ppm.personal_payment_method_id
698: and ppm.effective_end_date = (l_effective_date-1);
699: else

Line 1406: from pay_personal_payment_methods_f ppm

1402: (p_assignment_id in number
1403: ,p_effective_date in date
1404: ) is
1405: select null
1406: from pay_personal_payment_methods_f ppm
1407: where ppm.assignment_id = p_assignment_id
1408: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1409: and p_effective_date between
1410: ppm.effective_start_date and ppm.effective_end_date

Line 1423: from pay_personal_payment_methods_f ppm

1419: (p_assignment_id in number
1420: ,p_effective_date in date
1421: ) is
1422: select null
1423: from pay_personal_payment_methods_f ppm
1424: , pay_org_payment_methods_f opm
1425: where ppm.assignment_id = p_assignment_id
1426: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1427: and p_effective_date between

Line 1435: from pay_personal_payment_methods_f ppm1

1431: opm.effective_start_date and opm.effective_end_date
1432: and opm.defined_balance_id is not null
1433: and ( (p_run_type_id is not null) or (ppm.priority <
1434: (select max(priority)
1435: from pay_personal_payment_methods_f ppm1
1436: where ppm1.assignment_id = p_assignment_id
1437: and nvl(ppm1.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1438: and p_effective_date between
1439: ppm1.effective_start_date and ppm1.effective_end_date)))

Line 2454: from pay_personal_payment_methods_f ppm,

2450: /*
2451: -- Curosor to get the actual percentage/amount of the ppm.
2452: cursor fetch_org_values is
2453: select ppm.AMOUNT, ppm.PERCENTAGE
2454: from pay_personal_payment_methods_f ppm,
2455: pay_pss_transaction_steps pps
2456: where pps.transaction_step_id = p_transaction_step_id
2457: and pps.PERSONAL_PAYMENT_METHOD_ID = ppm.PERSONAL_PAYMENT_METHOD_ID
2458: and pps.ASSIGNMENT_ID= ppm.ASSIGNMENT_ID

Line 2500: /*fetch the oriiginal values from the pay_personal_payment_methods_f table

2496: /*Below are the changes done based on the bug#7230549. This is not
2497: expected functionality. So we are revering back the changes.
2498: If the customer still want this functionality then we need to
2499: create a profile and switch this functionality based on the profile.*/
2500: /*fetch the oriiginal values from the pay_personal_payment_methods_f table
2501: open fetch_org_values;
2502: fetch fetch_org_values into l_org_amt, l_org_percent;
2503:
2504: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'l_org_amt-percent : ' || l_org_amt || '-' || l_org_percent , 2);

Line 3448: from pay_personal_payment_methods_f ppm

3444: select ppm.personal_payment_method_id ppmid
3445: , ppm.object_version_number ovn
3446: , ppm.effective_start_date esd
3447: , ppm.priority priority
3448: from pay_personal_payment_methods_f ppm
3449: , pay_org_payment_methods_f opm
3450: where ppm.assignment_id = p_assignment_id
3451: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
3452: and p_effective_date

Line 4100: from pay_personal_payment_methods_f ppm

4096: (p_assignment_id in number
4097: ,p_effective_date in date
4098: ) is
4099: select null
4100: from pay_personal_payment_methods_f ppm
4101: where ppm.assignment_id = p_assignment_id
4102: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
4103: and ppm.effective_start_date > p_effective_date;
4104: begin