APPS.PAY_PPM_BUS dependencies on PAY_BALANCE_TYPES

Line 51: from pay_balance_types blt,

47: -- Check if the related balance type is remunerative
48:
49: cursor csr_chk_blt is
50: select null
51: from pay_balance_types blt,
52: pay_defined_balances dfb,
53: pay_org_payment_methods_f opm
54: where blt.assignment_remuneration_flag = 'Y'
55: and blt.balance_type_id = dfb.balance_type_id

Line 331: , pay_balance_types bt

327: or exists
328: (select null
329: from pay_org_payment_methods_f opm
330: , pay_defined_balances db
331: , pay_balance_types bt
332: where opm.org_payment_method_id = ppm.org_payment_method_id
333: and p_effective_date between
334: opm.effective_start_date and opm.effective_end_date
335: and db.defined_balance_id = opm.defined_balance_id

Line 357: , pay_balance_types bt

353: or exists
354: (select null
355: from pay_org_payment_methods_f opm
356: , pay_defined_balances db
357: , pay_balance_types bt
358: where opm.org_payment_method_id = ppm2.org_payment_method_id
359: and p_effective_date between
360: opm.effective_start_date and opm.effective_end_date
361: and db.defined_balance_id = opm.defined_balance_id

Line 909: , pay_balance_types bt

905: cursor get_curcode is
906: select bt.currency_code
907: from pay_org_payment_methods_f opm
908: , pay_defined_balances db
909: , pay_balance_types bt
910: where org_payment_method_id = p_org_payment_method_id
911: and p_effective_date between
912: opm.effective_start_date and opm.effective_end_date
913: and db.defined_balance_id = opm.defined_balance_id

Line 1238: , pay_balance_types bt

1234: or exists
1235: (select null
1236: from pay_org_payment_methods_f opm
1237: , pay_defined_balances db
1238: , pay_balance_types bt
1239: where opm.org_payment_method_id = ppm.org_payment_method_id
1240: and p_effective_date between
1241: opm.effective_start_date and opm.effective_end_date
1242: and db.defined_balance_id = opm.defined_balance_id