APPS.PAY_PPM_BUS dependencies on PAY_DEFINED_BALANCES

Line 52: pay_defined_balances dfb,

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
56: and dfb.defined_balance_id = opm.defined_balance_id

Line 330: , pay_defined_balances db

326: and (ppm.priority <> 1
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

Line 356: , pay_defined_balances db

352: and (ppm2.priority <> 1
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

Line 908: , pay_defined_balances db

904: -- Currency code for monetary amount comes from the balance.
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

Line 1237: , pay_defined_balances db

1233: and (ppm.priority <> 1
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