[Home] [Help]
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
39: between opm.effective_start_date
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
510: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
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
849: and p_effective_date between
850: paa.effective_start_date and paa.effective_end_date
851: and opm.org_payment_method_id = p_org_payment_id
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
874: and p_effective_date between
875: paa.effective_start_date and paa.effective_end_date
876: and popmu.payroll_id = paa.payroll_id
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
1091: and p_effective_date between
1092: paa.effective_start_date and paa.effective_end_date
1093: and popmu.payroll_id = paa.payroll_id
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
1285: and pap.payroll_id = paa.payroll_id
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
3877: AND ppt.territory_code = TERR.territory_code (+);
3887: AND org.ORGANIZATION_ID = org_inf.ORGANIZATION_ID
3888: AND ORG_INFORMATION_CONTEXT = 'Business Group Information'
3889: AND org_inf.org_information9 = TERR.territory_code (+);
3890:
3891: l_ppt_territory_code pay_payment_types.territory_code%TYPE;
3892: l_bg_country hr_organization_information.org_information9%TYPE;
3893: l_territory_desc FND_TERRITORIES_VL.territory_short_name%TYPE;
3894:
3895: begin
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
3963: and leg.legislation_code = DECODE(PTS.territory_code, null, HR_API.RETURN_LEGISLATION_CODE(OPM.BUSINESS_GROUP_ID),PTS.territory_code)
4043:
4044: function get_payment_type_name(p_opm_id number,
4045: p_effective_date date) RETURN varchar2 is
4046:
4047: l_payment_type_name PAY_PAYMENT_TYPES.PAYMENT_TYPE_NAME%TYPE;
4048:
4049: begin
4050: SELECT PT.PAYMENT_TYPE_NAME
4051: INTO l_payment_type_name
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;