APPS.PAY_US_ARCHIVE dependencies on FF_FORMULAS_F

Line 2614: l_formula_name ff_formulas_f.formula_name%TYPE;

2610:
2611: l_jurisdiction_code VARCHAR2(30);
2612: l_tax_unit_id NUMBER(15);
2613: l_archive boolean:= FALSE;
2614: l_formula_name ff_formulas_f.formula_name%TYPE;
2615: l_step number;
2616: ld_end_date DATE;
2617: ld_start_date DATE;
2618: ln_business_group_id NUMBER;

Line 2646: from ff_formulas_f ff,

2642:
2643: begin
2644: select ff.formula_name
2645: into l_formula_name
2646: from ff_formulas_f ff,
2647: ff_compiled_info_f fci
2648: where ff.formula_name = 'US_YEP_BOX_12'
2649: and fci.formula_id = ff.formula_id;
2650: exception

Line 2660: from ff_formulas_f ff,

2656: l_step := 2;
2657: begin
2658: select ff.formula_name
2659: into l_formula_name
2660: from ff_formulas_f ff,
2661: ff_compiled_info_f fci
2662: where ff.formula_name = 'US_YEP_BOX_14'
2663: and fci.formula_id = ff.formula_id;
2664: exception

Line 2673: from ff_formulas_f ff,

2669: l_step := 3;
2670: begin
2671: select ff.formula_name
2672: into l_formula_name
2673: from ff_formulas_f ff,
2674: ff_compiled_info_f fci
2675: where ff.formula_name = 'US_YEP_FEDERAL'
2676: and fci.formula_id = ff.formula_id;
2677: exception

Line 2686: from ff_formulas_f ff,

2682: l_step := 4;
2683: begin
2684: select ff.formula_name
2685: into l_formula_name
2686: from ff_formulas_f ff,
2687: ff_compiled_info_f fci
2688: where ff.formula_name = 'US_YEP_LOCALITY'
2689: and fci.formula_id = ff.formula_id;
2690: exception

Line 2699: from ff_formulas_f ff,

2695: l_step := 5;
2696: begin
2697: select ff.formula_name
2698: into l_formula_name
2699: from ff_formulas_f ff,
2700: ff_compiled_info_f fci
2701: where ff.formula_name = 'US_YEP_STATE'
2702: and fci.formula_id = ff.formula_id;
2703: exception