APPS.PQP_US_FF_FUNCTIONS dependencies on PAY_DEFINED_BALANCES

Line 168: pay_defined_balances pdb,

164: --+
165: CURSOR c_defined_bal IS
166: SELECT pdb.defined_balance_id
167: FROM pay_balance_types pbt,
168: pay_defined_balances pdb,
169: pay_balance_dimensions pbd
170: WHERE pbt.balance_name = l_bal_name
171: AND pbt.balance_type_id = pdb.balance_type_id
172: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 347: FROM pay_defined_balances pdb,

343: l_dimension_name pay_balance_dimensions.dimension_name%type;
344:
345: CURSOR c1 (c_balance_name varchar2, c_dimension_name varchar2) IS
346: SELECT defined_balance_id
347: FROM pay_defined_balances pdb,
348: pay_balance_types pbt,
349: pay_balance_dimensions pbd
350: WHERE pdb.balance_type_id = pbt.balance_type_id
351: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 594: FROM pay_defined_balances dbl

590:
591: CURSOR crs_get_defined_bal_id (p_bal_name VARCHAR2
592: ,p_dimension VARCHAR2) IS
593: SELECT dbl.defined_balance_id
594: FROM pay_defined_balances dbl
595: WHERE dbl.balance_type_id =
596: (SELECT balance_type_id
597: FROM pay_balance_types blt
598: WHERE blt.balance_name = p_bal_name