APPS.PY_ZA_BAL dependencies on PAY_DEFINED_BALANCES

Line 290: pay_defined_balances pdb,

286: --
287: cursor relevant(c_balance_type_id IN NUMBER,
288: c_db_item_suffix IN VARCHAR2) IS
289: select pdb.defined_balance_id from
290: pay_defined_balances pdb,
291: pay_balance_dimensions pbd
292: where pdb.balance_dimension_id = pbd.balance_dimension_id
293: and pbd.database_item_suffix = c_db_item_suffix
294: and pdb.balance_type_id = c_balance_type_id;

Line 524: pay_defined_balances DB,

520: DIM.dimension_name,
521: DIM.database_item_suffix ,
522: DIM.legislation_code
523: FROM
524: pay_defined_balances DB,
525: pay_balance_dimensions DIM
526: WHERE DB.defined_balance_id = p_defined_balance_id
527: AND DIM.balance_dimension_id = DB.balance_dimension_id;
528: --

Line 639: pay_defined_balances pdb

635: cursor get_balance_type_id(c_defined_balance_id IN NUMBER) IS
636: select pdb.balance_type_id,
637: pbd.dimension_name
638: from pay_balance_dimensions pbd,
639: pay_defined_balances pdb
640: where pdb.defined_balance_id = c_defined_balance_id
641: and pdb.balance_dimension_id = pbd.balance_dimension_id;
642: --
643: BEGIN

Line 718: pay_defined_balances pdb

714: cursor get_balance_type_id(c_defined_balance_id IN NUMBER) IS
715: select pdb.balance_type_id,
716: pbd.dimension_name
717: from pay_balance_dimensions pbd,
718: pay_defined_balances pdb
719: where pdb.defined_balance_id = c_defined_balance_id
720: and pdb.balance_dimension_id = pbd.balance_dimension_id;
721: --
722: BEGIN

Line 3352: FROM pay_defined_balances pdb,

3348: CURSOR csr_defined_balance_id(c_balance_type_id IN NUMBER,
3349: c_db_item_suffix IN VARCHAR2)
3350: IS
3351: SELECT pdb.defined_balance_id
3352: FROM pay_defined_balances pdb,
3353: pay_balance_dimensions pbd
3354: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
3355: AND pbd.database_item_suffix = c_db_item_suffix
3356: AND pdb.balance_type_id = c_balance_type_id;

Line 3519: FROM pay_defined_balances pdb,

3515: CURSOR csr_defined_balance_id(c_balance_type_id IN NUMBER,
3516: c_db_item_suffix IN VARCHAR2)
3517: IS
3518: SELECT pdb.defined_balance_id
3519: FROM pay_defined_balances pdb,
3520: pay_balance_dimensions pbd
3521: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
3522: AND pbd.database_item_suffix = c_db_item_suffix
3523: AND pdb.balance_type_id = c_balance_type_id;