APPS.PYNEGNET01 dependencies on PAY_DEFINED_BALANCES

Line 770: pay_defined_balances db

766: CURSOR bal_dim (p_bal_name VARCHAR2)
767: IS
768: SELECT db.defined_balance_id
769: FROM pay_balance_types bt,
770: pay_defined_balances db
771: WHERE bt.balance_name = p_bal_name AND
772: bt.balance_type_id = db.balance_type_id;
773: /* balances counter */
774: total_bal BINARY_INTEGER := v_total_balances;

Line 793: DELETE FROM pay_defined_balances

789: LOOP
790: ln_id :=dim_rec.defined_balance_id;
791: --
792: begin
793: DELETE FROM pay_defined_balances
794: WHERE defined_balance_id = ln_id;
795: EXCEPTION
796: WHEN NO_DATA_FOUND THEN NULL;
797: end;

Line 894: pay_defined_balances db

890: IS
891: SELECT bd.dimension_name
892: FROM pay_balance_types bt,
893: pay_balance_dimensions bd,
894: pay_defined_balances db
895: WHERE bt.balance_name = p_proto_bal_name AND
896: bt.balance_type_id = db.balance_type_id AND
897: db.balance_dimension_id = bd.balance_dimension_id;
898: /* balances counter */