APPS.PAY_US_ARCHIVE dependencies on FF_FORMULAS_F

Line 3124: l_formula_name ff_formulas_f.formula_name%TYPE;

3120:
3121: l_jurisdiction_code VARCHAR2(30);
3122: l_tax_unit_id NUMBER(15);
3123: l_archive boolean:= FALSE;
3124: l_formula_name ff_formulas_f.formula_name%TYPE;
3125: l_step number;
3126: ld_end_date DATE;
3127: ld_start_date DATE;
3128: ln_business_group_id NUMBER;

Line 3156: from ff_formulas_f ff,

3152:
3153: begin
3154: select ff.formula_name
3155: into l_formula_name
3156: from ff_formulas_f ff,
3157: ff_compiled_info_f fci
3158: where ff.formula_name = 'US_YEP_BOX_12'
3159: and fci.formula_id = ff.formula_id;
3160: exception

Line 3170: from ff_formulas_f ff,

3166: l_step := 2;
3167: begin
3168: select ff.formula_name
3169: into l_formula_name
3170: from ff_formulas_f ff,
3171: ff_compiled_info_f fci
3172: where ff.formula_name = 'US_YEP_BOX_14'
3173: and fci.formula_id = ff.formula_id;
3174: exception

Line 3183: from ff_formulas_f ff,

3179: l_step := 3;
3180: begin
3181: select ff.formula_name
3182: into l_formula_name
3183: from ff_formulas_f ff,
3184: ff_compiled_info_f fci
3185: where ff.formula_name = 'US_YEP_FEDERAL'
3186: and fci.formula_id = ff.formula_id;
3187: exception

Line 3196: from ff_formulas_f ff,

3192: l_step := 4;
3193: begin
3194: select ff.formula_name
3195: into l_formula_name
3196: from ff_formulas_f ff,
3197: ff_compiled_info_f fci
3198: where ff.formula_name = 'US_YEP_LOCALITY'
3199: and fci.formula_id = ff.formula_id;
3200: exception

Line 3209: from ff_formulas_f ff,

3205: l_step := 5;
3206: begin
3207: select ff.formula_name
3208: into l_formula_name
3209: from ff_formulas_f ff,
3210: ff_compiled_info_f fci
3211: where ff.formula_name = 'US_YEP_STATE'
3212: and fci.formula_id = ff.formula_id;
3213: exception