APPS.ZX_FORMULA_PKG dependencies on ZX_PROCESS_RESULTS

Line 497: FROM ZX_PROCESS_RESULTS

493: WHERE FORMULA_ID = X_FORMULA_ID;
494:
495: CURSOR C_PROC_RES is SELECT TAX_RULE_ID,
496: RESULT_ID
497: FROM ZX_PROCESS_RESULTS
498: WHERE Result_Type_Code = 'FORMULA'
499: AND Enabled_Flag = 'Y'
500: AND NUMERIC_RESULT = X_FORMULA_ID;
501:

Line 504: FROM ZX_PROCESS_RESULTS

500: AND NUMERIC_RESULT = X_FORMULA_ID;
501:
502: CURSOR C_RES_RULE_ID(p_cur_rule_id NUMBER, p_cur_result_id NUMBER) is
503: SELECT TAX_RULE_ID
504: FROM ZX_PROCESS_RESULTS
505: WHERE TAX_RULE_ID = p_cur_rule_id
506: and Enabled_Flag = 'Y'
507: and RESULT_ID <> p_cur_result_id;
508:

Line 523: -- Logic to update ZX_PROCESS_RESULTS and ZX_RULES tables,

519: ctr NUMBER;
520:
521: begin
522:
523: -- Logic to update ZX_PROCESS_RESULTS and ZX_RULES tables,
524: -- to disable the associated results and rules of this formula*/
525: OPEN C1;
526: FETCH C1 INTO p_Enabled_Flag;
527: CLOSE C1;

Line 583: UPDATE ZX_PROCESS_RESULTS

579: CLOSE C_RES_RULE_ID;
580: END LOOP;
581: CLOSE C_PROC_RES;
582:
583: UPDATE ZX_PROCESS_RESULTS
584: SET Enabled_Flag = 'N'
585: WHERE Result_Type_Code = 'FORMULA'
586: AND Enabled_Flag = 'Y'
587: AND NUMERIC_RESULT = X_FORMULA_ID;