APPS.PYNEGNET01 dependencies on PAY_ELEMENT_TYPES_F

Line 412: select element_type_id from pay_element_types_f

408: total_post_inp BINARY_INTEGER := 5;
409: total_arr_inp BINARY_INTEGER := 2;
410:
411: cursor crs_post_element_type_id (el_cnt number) is
412: select element_type_id from pay_element_types_f
413: where element_name = element_name_list (el_cnt) || 'POST_VERTEX';
414:
415: cursor crs_post_input_value_id (p_element_type_id number, p_inp_cnt number) is
416: select input_value_id from pay_input_values_f

Line 421: select element_type_id from pay_element_types_f

417: where element_type_id = p_element_type_id and
418: name = post_inp_value_list(p_inp_cnt);
419:
420: cursor crs_arr_element_type_id (el_count number) is
421: select element_type_id from pay_element_types_f
422: where element_name = element_name_list (el_count) || 'ARR';
423:
424: cursor crs_arr_input_value_id (p_element_type_id number, p_inp_cnt number) is
425: select input_value_id from pay_input_values_f

Line 739: pay_element_types_f ele

735: from dual
736: where
737: exists ( select 'x'
738: from pay_run_results rr,
739: pay_element_types_f ele
740: where
741: ele.element_type_id = rr.element_type_id
742: and ele.element_name in ( p_element_string||'POST_VERTEX', p_element_string||'ARR')
743: ) ;

Line 1094: pay_element_types_f et

1090: CURSOR arr_inp (p_arr_name VARCHAR2)
1091: IS
1092: SELECT iv.input_value_id
1093: FROM pay_input_values_f iv,
1094: pay_element_types_f et
1095: WHERE et.element_name = p_arr_name AND
1096: et.element_type_id = iv.element_type_id;
1097: /* balances counter */
1098: total_el BINARY_INTEGER := v_total_elements;

Line 1165: DELETE FROM pay_element_types_f

1161: LOOP
1162: if el_cnt in (3,9,10) then
1163: lc_name := element_name_list (el_cnt) || 'ARR';
1164: begin
1165: DELETE FROM pay_element_types_f
1166: WHERE element_name = lc_name and
1167: business_group_id is null;
1168: EXCEPTION
1169: WHEN NO_DATA_FOUND THEN NULL;

Line 1203: pay_element_types_f et

1199: CURSOR arr_inp (p_arr_name VARCHAR2)
1200: IS
1201: SELECT iv.input_value_id
1202: FROM pay_input_values_f iv,
1203: pay_element_types_f et
1204: WHERE et.element_name = p_arr_name AND
1205: et.element_type_id = iv.element_type_id;
1206: /* balances counter */
1207: total_el BINARY_INTEGER := v_total_elements;

Line 1578: pay_element_types_f et

1574: CURSOR post_inp (p_post_name VARCHAR2)
1575: IS
1576: SELECT iv.input_value_id
1577: FROM pay_input_values_f iv,
1578: pay_element_types_f et
1579: WHERE et.element_name = p_post_name AND
1580: et.element_type_id = iv.element_type_id;
1581: /* balances counter */
1582: total_el BINARY_INTEGER := v_total_elements;

Line 1629: pay_element_types_f petf

1625:
1626: cursor csr_all_processing_rules (p_lc_name varchar2) is
1627: SELECT psprf.status_processing_rule_id
1628: FROM pay_status_processing_rules_f psprf,
1629: pay_element_types_f petf
1630: WHERE petf.element_type_id = psprf.element_type_id and
1631: petf.element_name = p_lc_name and
1632: petf.business_group_id is null;
1633: BEGIN

Line 1644: DELETE FROM pay_element_types_f

1640: if el_cnt in (3,9,10) then
1641:
1642: lc_name := element_name_list (el_cnt) || 'POST_VERTEX';
1643: begin
1644: DELETE FROM pay_element_types_f
1645: WHERE element_name = lc_name and
1646: business_group_id is null;
1647: EXCEPTION
1648: WHEN NO_DATA_FOUND THEN NULL;

Line 1687: FROM pay_element_types_f

1683:
1684: BEGIN
1685: SELECT element_type_id
1686: INTO ln_id
1687: FROM pay_element_types_f
1688: WHERE element_name = lc_name;
1689: EXCEPTION
1690: WHEN NO_DATA_FOUND THEN NULL;
1691: END;

Line 1913: pay_element_types_f et

1909: CURSOR first_inp (p_post_name VARCHAR2)
1910: IS
1911: SELECT iv.input_value_id
1912: FROM pay_input_values_f iv,
1913: pay_element_types_f et
1914: WHERE et.element_name = p_post_name AND
1915: et.element_type_id = iv.element_type_id
1916: ;
1917:

Line 1930: FROM pay_element_types_f

1926: --
1927: BEGIN
1928: SELECT element_type_id
1929: INTO ln_vertex_id
1930: FROM pay_element_types_f
1931: WHERE element_name = lc_name;
1932: EXCEPTION
1933: WHEN NO_DATA_FOUND THEN NULL;
1934: END;

Line 1974: pay_element_types_f et

1970: BEGIN
1971: SELECT status_processing_rule_id
1972: INTO ln_stat_id
1973: FROM pay_status_processing_rules_f sp,
1974: pay_element_types_f et
1975: WHERE et.element_name = 'VERTEX_RESULTS'
1976: AND et.element_type_id = sp.element_type_id;
1977: EXCEPTION
1978: WHEN NO_DATA_FOUND THEN NULL;

Line 2014: from pay_element_types_f

2010: procedure cleanup is
2011: cursor sel_input (p_element varchar2) is
2012: select
2013: element_type_id
2014: from pay_element_types_f
2015: where
2016: element_name = p_element
2017: and legislation_code = 'US'
2018: ;

Line 2092: select element_type_id from pay_element_types_f

2088: l_balance_name varchar2(30);
2089: l_assign_list BINARY_INTEGER;
2090:
2091: cursor crs_arr_element_type_id (el_count number) is
2092: select element_type_id from pay_element_types_f
2093: where element_name = element_name_list (el_count) || 'ARR';
2094:
2095: CURSOR csr_bal_feeds (p_arr_element_type_id number)
2096: IS

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;

Line 2197: pay_element_types_f petf

2193: cursor csr_run_results is
2194: select prrv.run_result_id, prrv.input_value_id, prrv.result_value
2195: from pay_run_result_values prrv,
2196: pay_input_values_f pivf,
2197: pay_element_types_f petf
2198: where prrv.input_value_id = pivf.input_value_id and
2199: upper(pivf.name) = 'PAY VALUE' and
2200: pivf.element_type_id = petf.element_type_id and
2201: petf.element_name like '%_ARR' and