APPS.PYNEGNET01 dependencies on PAY_BALANCE_TYPES

Line 430: select balance_type_id from pay_balance_types

426: where element_type_id = p_element_type_id and
427: name = arr_inp_value_list(p_inp_cnt);
428:
429: cursor crs_arr_bal_id (p_bal_cnt number) is
430: select balance_type_id from pay_balance_types
431: where balance_name = arrear_bal_name_list (p_bal_cnt);
432:
433:
434: BEGIN

Line 610: FROM pay_balance_types

606: LOOP
607: lc_name := arr_bal_feed_name_list (feed_cnt);
608: SELECT balance_type_id
609: INTO ln_id
610: FROM pay_balance_types
611: WHERE balance_name = lc_name;
612: arr_bal_feed_id_list (feed_cnt) := ln_id;
613: feed_cnt := feed_cnt + 1;
614: END LOOP;

Line 673: FROM pay_balance_types

669: LOOP
670: lc_name := whld_bal_feed_name_list (feed_cnt);
671: SELECT balance_type_id
672: INTO ln_id
673: FROM pay_balance_types
674: WHERE balance_name = lc_name;
675: whld_bal_feed_id_list (feed_cnt) := ln_id;
676: feed_cnt := feed_cnt + 1;
677: END LOOP;

Line 769: FROM pay_balance_types bt,

765: IS
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 */

Line 814: FROM pay_balance_types bt,

810: IS
811: CURSOR bal_dim (p_bal_name VARCHAR2)
812: IS
813: SELECT bf.balance_feed_id
814: FROM pay_balance_types bt,
815: pay_balance_feeds_f bf
816: WHERE
817: bt.balance_name = p_bal_name AND
818: bt.balance_type_id = bf.balance_type_id;

Line 872: DELETE FROM pay_balance_types

868: LOOP
869: if bal_cnt in (3,9,10) then
870: lc_name := arrear_bal_name_list (bal_cnt);
871: begin
872: DELETE FROM pay_balance_types
873: WHERE balance_name = lc_name;
874: EXCEPTION
875: WHEN NO_DATA_FOUND THEN NULL;
876: end;

Line 892: FROM pay_balance_types bt,

888: IS
889: CURSOR bal_dim (p_proto_bal_name VARCHAR2)
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

Line 936: update pay_balance_types

932: --
933: -- update jurisdiction level for the arrears balance.
934: --
935: --
936: update pay_balance_types
937: set jurisdiction_level =
938: ( select jurisdiction_level
939: from pay_balance_types
940: where balance_name = lc_proto

Line 939: from pay_balance_types

935: --
936: update pay_balance_types
937: set jurisdiction_level =
938: ( select jurisdiction_level
939: from pay_balance_types
940: where balance_name = lc_proto
941: and business_group_id is null
942: and legislation_code = 'US')
943: where balance_type_id = ln_id;

Line 2099: pay_element_types_f petf, pay_balance_types pbt

2095: CURSOR csr_bal_feeds (p_arr_element_type_id number)
2096: IS
2097: SELECT pbf.balance_feed_id, pbt.balance_name
2098: FROM pay_balance_feeds_f pbf, pay_input_values_f pivf,
2099: pay_element_types_f petf, pay_balance_types pbt
2100: WHERE pbf.input_value_id = pivf.input_value_id and
2101: petf.element_type_id = pivf.element_type_id and
2102: petf.element_type_id = p_arr_element_type_id and
2103: pbf.balance_type_id = pbt.balance_type_id;