[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
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
444: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
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
780: and p_effective_date between
781: paa.effective_start_date and paa.effective_end_date
782: and opm.org_payment_method_id = p_org_payment_id
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
805: and p_effective_date between
806: paa.effective_start_date and paa.effective_end_date
807: and popmu.payroll_id = paa.payroll_id
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
1016: and p_effective_date between
1017: paa.effective_start_date and paa.effective_end_date
1018: and popmu.payroll_id = paa.payroll_id
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
1210: and pap.payroll_id = paa.payroll_id
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
3541: AND ppt.territory_code = TERR.territory_code (+);
3551: AND org.ORGANIZATION_ID = org_inf.ORGANIZATION_ID
3552: AND ORG_INFORMATION_CONTEXT = 'Business Group Information'
3553: AND org_inf.org_information9 = TERR.territory_code (+);
3554:
3555: l_ppt_territory_code pay_payment_types.territory_code%TYPE;
3556: l_bg_country hr_organization_information.org_information9%TYPE;
3557: l_territory_desc FND_TERRITORIES_VL.territory_short_name%TYPE;
3558:
3559: begin
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
3627: and leg.legislation_code = DECODE(PTS.territory_code, null, HR_API.RETURN_LEGISLATION_CODE(OPM.BUSINESS_GROUP_ID),PTS.territory_code)