DBA Data[Home] [Help]

APPS.PQP_CANDM_UPG dependencies on PAY_ELEMENT_TYPES_F

Line 64: --,pay_element_types_f petf

60: ,fff.compile_flag
61: ,paf.status_processing_rule_id status_processing_rule_id
62: FROM ff_formulas_f fff
63: ,PAY_STATUS_PROCESSING_RULES_F paf
64: --,pay_element_types_f petf
65: WHERE (formula_name
66: LIKE NVL(p_formula_name,'%_MILEAGE_CLAIM_PVT')
67: )
68: AND fff.formula_id=paf.formula_id

Line 101: FROM pay_element_types_f petf

97: l_short_formula_name VARCHAR2(80);
98:
99: CURSOR c_elename(cformula_id number,cbusiness_group_id number) IS
100: SELECT element_name
101: FROM pay_element_types_f petf
102: WHERE element_type_id = (SELECT distinct(pspr.element_type_id)
103: FROM pay_status_processing_rules_f pspr
104: ,pay_element_type_extra_info pete
105: WHERE pspr.formula_id =cformula_id