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:
355:

Line 505: , pay_org_payment_methods_f opm

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

Line 844: from pay_org_payment_methods_f opm

840: ,p_category in varchar2
841: ,p_org_payment_id in number
842: ) is
843: select opm.org_payment_method_id opmid
844: from pay_org_payment_methods_f opm
845: , per_all_assignments_f paa
846: , pay_org_pay_method_usages_f popmu
847: , pay_payment_types ppt
848: where paa.assignment_id = p_assignment_id

Line 869: from pay_org_payment_methods_f opm

865: ,p_effective_date in date
866: ,p_category in varchar2
867: ) is
868: select opm.org_payment_method_id opmid
869: from pay_org_payment_methods_f opm
870: , per_all_assignments_f paa
871: , pay_org_pay_method_usages_f popmu
872: , pay_payment_types ppt
873: where paa.assignment_id = p_assignment_id

Line 1086: from pay_org_payment_methods_f opm

1082: ,p_category in varchar2
1083: ) is
1084: select opm.org_payment_method_name name
1085: , opm.org_payment_method_id opmid
1086: from pay_org_payment_methods_f opm
1087: , per_all_assignments_f paa
1088: , pay_org_pay_method_usages_f popmu
1089: , pay_payment_types ppt
1090: where paa.assignment_id = p_assignment_id

Line 1280: , pay_org_payment_methods_f popm

1276: , pap.prl_information3
1277: , paa.payroll_id
1278: from per_all_assignments_f paa
1279: , pay_all_payrolls_f pap
1280: , pay_org_payment_methods_f popm
1281: , pay_payment_types ppt
1282: where paa.assignment_id = p_assignment_id
1283: and p_effective_date between
1284: paa.effective_start_date and paa.effective_end_date

Line 1424: , pay_org_payment_methods_f opm

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

Line 3449: , pay_org_payment_methods_f opm

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

Line 3872: FROM pay_org_payment_methods_f pom,

3868: cursor c_get_country_code (
3869: cp_org_payment_method_id number) IS
3870: SELECT ppt.territory_code,
3871: TERR.territory_short_name
3872: FROM pay_org_payment_methods_f pom,
3873: pay_payment_types ppt,
3874: FND_TERRITORIES_VL TERR
3875: WHERE pom.org_payment_method_id = cp_org_payment_method_id
3876: AND pom.payment_type_id = ppt.payment_type_id

Line 3958: , PAY_ORG_PAYMENT_METHODS_F opm

3954: ,cp_bgid number ) IS
3955: select flex.id_flex_structure_code
3956: from pay_legislation_rules leg
3957: , fnd_id_flex_structures flex
3958: , PAY_ORG_PAYMENT_METHODS_F opm
3959: , PAY_PAYMENT_TYPES PTS
3960: where opm.ORG_PAYMENT_METHOD_ID = cp_opm_id
3961: and opm.BUSINESS_GROUP_ID = cp_bgid
3962: and opm.PAYMENT_TYPE_ID = PTS.PAYMENT_TYPE_ID

Line 4009: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,

4005:
4006: cursor c_get_opm_name ( cp_opmid number,
4007: cp_bgid number) is
4008: select OPMTL.ORG_PAYMENT_METHOD_NAME
4009: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,
4010: PAY_ORG_PAYMENT_METHODS_F OPM
4011: where OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
4012: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
4013: AND BUSINESS_GROUP_ID + 0 = cp_bgid

Line 4010: PAY_ORG_PAYMENT_METHODS_F OPM

4006: cursor c_get_opm_name ( cp_opmid number,
4007: cp_bgid number) is
4008: select OPMTL.ORG_PAYMENT_METHOD_NAME
4009: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,
4010: PAY_ORG_PAYMENT_METHODS_F OPM
4011: where OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
4012: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
4013: AND BUSINESS_GROUP_ID + 0 = cp_bgid
4014: AND OPMTL.LANGUAGE = USERENV('LANG');

Line 4016: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F_TL.ORG_PAYMENT_METHOD_NAME%TYPE;

4012: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
4013: AND BUSINESS_GROUP_ID + 0 = cp_bgid
4014: AND OPMTL.LANGUAGE = USERENV('LANG');
4015:
4016: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F_TL.ORG_PAYMENT_METHOD_NAME%TYPE;
4017: Begin
4018: l_payment_method_name := null;
4019:
4020: open c_get_opm_name(p_org_payment_method_id,p_business_group_id);

Line 4028: l_is_foreign_transaction PAY_ORG_PAYMENT_METHODS_F.PMETH_INFORMATION9%TYPE;

4024: end get_org_method_name;
4025:
4026: function is_foreign_transaction(p_opm_id in number,
4027: p_effective_date DATE) return varchar is
4028: l_is_foreign_transaction PAY_ORG_PAYMENT_METHODS_F.PMETH_INFORMATION9%TYPE;
4029: begin
4030: select popm.PMETH_INFORMATION9
4031: INTO l_is_foreign_transaction
4032: from pay_org_payment_methods_f popm

Line 4032: from pay_org_payment_methods_f popm

4028: l_is_foreign_transaction PAY_ORG_PAYMENT_METHODS_F.PMETH_INFORMATION9%TYPE;
4029: begin
4030: select popm.PMETH_INFORMATION9
4031: INTO l_is_foreign_transaction
4032: from pay_org_payment_methods_f popm
4033: where popm.ORG_PAYMENT_METHOD_ID = p_opm_id
4034: and HR_API.RETURN_LEGISLATION_CODE(POPM.BUSINESS_GROUP_ID)='US'
4035: AND p_effective_date
4036: BETWEEN popm.effective_start_date AND popm.effective_end_date;

Line 4052: FROM PAY_PAYMENT_TYPES PT, PAY_ORG_PAYMENT_METHODS_F PM

4048:
4049: begin
4050: SELECT PT.PAYMENT_TYPE_NAME
4051: INTO l_payment_type_name
4052: FROM PAY_PAYMENT_TYPES PT, PAY_ORG_PAYMENT_METHODS_F PM
4053: WHERE PM.ORG_PAYMENT_METHOD_ID = P_OPM_ID
4054: AND PM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
4055: AND P_EFFECTIVE_DATE BETWEEN PM.EFFECTIVE_START_DATE
4056: AND PM.EFFECTIVE_END_DATE;