APPS.PYNEGNET01 dependencies on PAY_BALANCE_FEEDS_F

Line 815: pay_balance_feeds_f bf

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;
819: /* balances counter */

Line 839: DELETE FROM pay_balance_feeds_f

835: FOR dim_rec IN bal_dim(lc_name)
836: LOOP
837: ln_id :=dim_rec.balance_feed_id;
838: begin
839: DELETE FROM pay_balance_feeds_f
840: WHERE balance_feed_id = ln_id;
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN NULL;
843: end;

Line 1123: DELETE FROM pay_balance_feeds_f

1119: WHILE spec_cnt <= total_spec
1120: LOOP
1121: ln_spec_id := arr_bal_feed_id_list (spec_cnt);
1122: begin
1123: DELETE FROM pay_balance_feeds_f
1124: WHERE input_value_id = ln_id AND
1125: balance_type_id = ln_spec_id;
1126: EXCEPTION
1127: WHEN NO_DATA_FOUND THEN NULL;

Line 1235: DELETE FROM pay_balance_feeds_f

1231: WHILE spec_cnt <= total_spec
1232: LOOP
1233: ln_spec_id := arr_bal_feed_id_list (spec_cnt);
1234: begin
1235: DELETE FROM pay_balance_feeds_f
1236: WHERE input_value_id = ln_id AND
1237: ( balance_type_id = ln_spec_id
1238: OR balance_type_id = ln_whld_id);
1239: EXCEPTION

Line 1555: update pay_balance_feeds_f

1551: hr_utility.set_location('pynegnet01.create_arr_feed',4);
1552: --
1553: -- package above does not support effective_start_date
1554: --
1555: update pay_balance_feeds_f
1556: set business_group_id = null,
1557: effective_start_date = v_effective_start_date
1558: where balance_type_id = ln_balance_type_id
1559: ;

Line 2038: update pay_balance_feeds_f

2034: where element_type_id = lc_element_type_id
2035: and business_group_id is not null
2036: ;
2037: --
2038: update pay_balance_feeds_f
2039: set business_group_id = null,
2040: effective_start_date = v_effective_start_date
2041: where input_value_id in
2042: (select input_value_id

Line 2098: FROM pay_balance_feeds_f pbf, pay_input_values_f pivf,

2094:
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

Line 2121: update pay_balance_feeds_f

2117: WHILE feed_cnt <= 6 loop
2118: fetch csr_bal_feeds into l_balance_feed_id, l_balance_name;
2119: -- csr_bal_feeds%found LOOP
2120: l_assign_list := arr_assign_list(el_cnt);
2121: update pay_balance_feeds_f
2122: set scale = decode
2123: (upper(l_balance_name),
2124: upper(arrear_bal_name_list(l_assign_list)),-1,
2125: upper(arr_bal_feed_name_list (2)),-1,