APPS.PYNEGNET01 dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 1628: FROM pay_status_processing_rules_f psprf,

1624: l_rule_id NUMBER := 0;
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;

Line 1697: DELETE FROM pay_status_processing_rules_f

1693: if el_cnt in (3,9,10) then
1694:
1695: IF ln_id > 0 THEN
1696:
1697: DELETE FROM pay_status_processing_rules_f
1698: WHERE element_type_id = ln_id;
1699: DELETE FROM pay_formula_result_rules_f
1700: WHERE status_processing_rule_id = l_rule_id;
1701: END IF;

Line 1822: from pay_status_processing_rules_f

1818: post_element_id_list (el_cnt) := ln_id;
1819: --
1820: else
1821: select status_processing_rule_id into ln_stat_id
1822: from pay_status_processing_rules_f
1823: where element_type_id = post_element_id_list (el_cnt);
1824: end if;
1825:
1826: /* insert_formula result rules */

Line 1973: FROM pay_status_processing_rules_f sp,

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