APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 723: l_formula_name pay_shadow_formulas.formula_name%TYPE;

719: l_eei_info_id NUMBER;
720: l_ovn_eei NUMBER;
721: l_abs_ele_correction_pp NUMBER := p_abs_ele_processing_priority - 50;
722: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
723: l_formula_name pay_shadow_formulas.formula_name%TYPE;
724: l_formula_id NUMBER;
725: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
726: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
727: l_exists VARCHAR2(1);

Line 1049: -- FROM pay_shadow_formulas

1045: --
1046: -- CURSOR csr_get_formula_id
1047: -- IS
1048: -- SELECT formula_id
1049: -- FROM pay_shadow_formulas
1050: -- WHERE formula_name = p_formula_name
1051: -- AND template_type = 'T';
1052: ---- AND ((business_group_id is not null AND business_group_id = p_bg_id) OR
1053: ---- (legislation_code is not null AND legislation_code = 'GB') OR