APPS.HR_BIS_ORG_PERF dependencies on FF_FORMULAS_F

Line 136: from ff_formulas_f

132: cursor c_get_bgt_formula
133: ( cp_business_group_id NUMBER )
134: is
135: select formula_id
136: from ff_formulas_f
137: where cp_business_group_id = business_group_id
138: and trunc(sysdate) between effective_start_date and effective_end_date
139: and formula_name = 'BUDGET_'||p_budget_metric;
140:

Line 143: from ff_formulas_f

139: and formula_name = 'BUDGET_'||p_budget_metric;
140:
141: cursor c_get_tmplt_formula is
142: select formula_id
143: from ff_formulas_f
144: where business_group_id is null
145: and trunc(sysdate) between effective_start_date and effective_end_date
146: and formula_name = 'TEMPLATE_'||p_budget_metric;
147:

Line 391: from ff_formulas_f

387: cursor c_get_bgt_formula
388: ( cp_business_group_id NUMBER )
389: is
390: select formula_id
391: from ff_formulas_f
392: where cp_business_group_id = business_group_id
393: and trunc(sysdate) between effective_start_date and effective_end_date
394: and formula_name = 'BUDGET_'||p_budget_metric;
395:

Line 399: from ff_formulas_f

395:
396: cursor c_get_tmplt_formula
397: is
398: select formula_id
399: from ff_formulas_f
400: where business_group_id is null
401: and trunc(sysdate) between effective_start_date and effective_end_date
402: and formula_name = 'TEMPLATE_'||p_budget_metric;
403:

Line 644: from ff_formulas_f

640: ( cp_business_group_id NUMBER
641: , cp_budget_metric VARCHAR2 )
642: is
643: select formula_id
644: from ff_formulas_f
645: where cp_business_group_id = business_group_id
646: and trunc(sysdate) between effective_start_date and effective_end_date
647: and formula_name = 'BUDGET_'||cp_budget_metric;
648:

Line 653: from ff_formulas_f

649: cursor c_get_tmplt_formula
650: ( cp_budget_metric VARCHAR2 )
651: is
652: select formula_id
653: from ff_formulas_f
654: where business_group_id is null
655: and trunc(sysdate) between effective_start_date and effective_end_date
656: and formula_name = 'TEMPLATE_'||cp_budget_metric;
657:

Line 835: from ff_formulas_f

831: ( cp_business_group_id NUMBER
832: , cp_budget_metric VARCHAR2 )
833: is
834: select formula_id
835: from ff_formulas_f
836: where cp_business_group_id = business_group_id
837: and trunc(sysdate) between effective_start_date and effective_end_date
838: and formula_name = 'BUDGET_'||cp_budget_metric;
839:

Line 844: from ff_formulas_f

840: cursor c_get_tmplt_formula
841: ( cp_budget_metric VARCHAR2 )
842: is
843: select formula_id
844: from ff_formulas_f
845: where business_group_id is null
846: and trunc(sysdate) between effective_start_date and effective_end_date
847: and formula_name = 'TEMPLATE_'||cp_budget_metric;
848: