eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PPMV4_SS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 34: pay_org_payment_methods_f opm,

30: from sys.dual
31: where not exists
32: (select null
33: from pay_pss_transaction_steps pts,
34: pay_org_payment_methods_f opm,
35: pay_payment_types ppt
36: where pts.transaction_step_id = p_transaction_step_id
37: and opm.org_payment_method_id = pts.org_payment_method_id
38: and pts.effective_date

Line 351: , pay_org_payment_methods_f opm

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
355: ppm.effective_start_date and ppm.effective_end_date

Line 439: , pay_org_payment_methods_f opm

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
443: where ppm.assignment_id = p_assignment_id

Line 775: from pay_org_payment_methods_f opm

771: ,p_category in varchar2
772: ,p_org_payment_id in number
773: ) is
774: select opm.org_payment_method_id opmid
775: from pay_org_payment_methods_f opm
776: , per_all_assignments_f paa
777: , pay_org_pay_method_usages_f popmu
778: , pay_payment_types ppt
779: where paa.assignment_id = p_assignment_id

Line 800: from pay_org_payment_methods_f opm

796: ,p_effective_date in date
797: ,p_category in varchar2
798: ) is
799: select opm.org_payment_method_id opmid
800: from pay_org_payment_methods_f opm
801: , per_all_assignments_f paa
802: , pay_org_pay_method_usages_f popmu
803: , pay_payment_types ppt
804: where paa.assignment_id = p_assignment_id

Line 1011: from pay_org_payment_methods_f opm

1007: ,p_category in varchar2
1008: ) is
1009: select opm.org_payment_method_name name
1010: , opm.org_payment_method_id opmid
1011: from pay_org_payment_methods_f opm
1012: , per_all_assignments_f paa
1013: , pay_org_pay_method_usages_f popmu
1014: , pay_payment_types ppt
1015: where paa.assignment_id = p_assignment_id

Line 1205: , pay_org_payment_methods_f popm

1201: , pap.prl_information3
1202: , paa.payroll_id
1203: from per_all_assignments_f paa
1204: , pay_all_payrolls_f pap
1205: , pay_org_payment_methods_f popm
1206: , pay_payment_types ppt
1207: where paa.assignment_id = p_assignment_id
1208: and p_effective_date between
1209: paa.effective_start_date and paa.effective_end_date

Line 1349: , pay_org_payment_methods_f opm

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
1353: ppm.effective_start_date and ppm.effective_end_date

Line 3188: , pay_org_payment_methods_f opm

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
3192: between ppm.effective_start_date and ppm.effective_end_date

Line 3536: FROM pay_org_payment_methods_f pom,

3532: cursor c_get_country_code (
3533: cp_org_payment_method_id number) IS
3534: SELECT ppt.territory_code,
3535: TERR.territory_short_name
3536: FROM pay_org_payment_methods_f pom,
3537: pay_payment_types ppt,
3538: FND_TERRITORIES_VL TERR
3539: WHERE pom.org_payment_method_id = cp_org_payment_method_id
3540: AND pom.payment_type_id = ppt.payment_type_id

Line 3622: , PAY_ORG_PAYMENT_METHODS_F opm

3618: ,cp_bgid number ) IS
3619: select flex.id_flex_structure_code
3620: from pay_legislation_rules leg
3621: , fnd_id_flex_structures flex
3622: , PAY_ORG_PAYMENT_METHODS_F opm
3623: , PAY_PAYMENT_TYPES PTS
3624: where opm.ORG_PAYMENT_METHOD_ID = cp_opm_id
3625: and opm.BUSINESS_GROUP_ID = cp_bgid
3626: and opm.PAYMENT_TYPE_ID = PTS.PAYMENT_TYPE_ID

Line 3673: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,

3669:
3670: cursor c_get_opm_name ( cp_opmid number,
3671: cp_bgid number) is
3672: select OPMTL.ORG_PAYMENT_METHOD_NAME
3673: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,
3674: PAY_ORG_PAYMENT_METHODS_F OPM
3675: where OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
3676: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
3677: AND BUSINESS_GROUP_ID + 0 = cp_bgid;

Line 3674: PAY_ORG_PAYMENT_METHODS_F OPM

3670: cursor c_get_opm_name ( cp_opmid number,
3671: cp_bgid number) is
3672: select OPMTL.ORG_PAYMENT_METHOD_NAME
3673: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,
3674: PAY_ORG_PAYMENT_METHODS_F OPM
3675: where OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
3676: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
3677: AND BUSINESS_GROUP_ID + 0 = cp_bgid;
3678:

Line 3679: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F_TL.ORG_PAYMENT_METHOD_NAME%TYPE;

3675: where OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
3676: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
3677: AND BUSINESS_GROUP_ID + 0 = cp_bgid;
3678:
3679: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F_TL.ORG_PAYMENT_METHOD_NAME%TYPE;
3680: Begin
3681: l_payment_method_name := null;
3682:
3683: open c_get_opm_name(p_org_payment_method_id,p_business_group_id);