APPS.PAY_PAP_BUS dependencies on FF_FORMULAS_F

Line 30: l_formula_name ff_formulas_f.formula_name%TYPE;

26: IS
27:
28: l_proc VARCHAR2(72) := g_package||'return_ff_name';
29: l_legislation_code per_business_groups.legislation_code%TYPE;
30: l_formula_name ff_formulas_f.formula_name%TYPE;
31:
32: --
33: -- Fetches the legislation code of the business group.
34: --

Line 47: FROM ff_formulas_f ff

43: -- legislation code are visible.
44: --
45: CURSOR csr_chk_and_return_ff IS
46: SELECT ff.formula_name
47: FROM ff_formulas_f ff
48: ,ff_formula_types ft
49: WHERE ff.formula_id = p_formula_id
50: AND ff.formula_type_id = ft.formula_type_id
51: AND ft.formula_type_name = p_formula_type_name

Line 354: -- DESCRIPTION Validates that the accrual formula exists in ff_formulas_f

350: -- ----------------------------------------------------------------------------
351: --
352: -- NAME chk_accrual_formula_id
353: --
354: -- DESCRIPTION Validates that the accrual formula exists in ff_formulas_f
355: -- globally, for the business group or for the legislation.
356: --
357: -- NOTES none
358: --

Line 368: l_accrual_formula ff_formulas_f.formula_name%TYPE;

364: ,p_accrual_formula_id IN NUMBER)
365: IS
366:
367: l_proc VARCHAR2(72) := g_package||'chk_accrual_formula_id';
368: l_accrual_formula ff_formulas_f.formula_name%TYPE;
369: l_api_updating BOOLEAN;
370:
371: BEGIN
372:

Line 426: -- DESCRIPTION Validates that the carry over formula exists in ff_formulas_f

422: -- ----------------------------------------------------------------------------
423: --
424: -- NAME chk_co_formula_id
425: --
426: -- DESCRIPTION Validates that the carry over formula exists in ff_formulas_f
427: -- globally, for the business group or for the legislation.
428: --
429: -- NOTES none
430: --

Line 441: l_accrual_formula ff_formulas_f.formula_name%TYPE;

437: ,p_co_formula_id IN NUMBER)
438: IS
439:
440: l_proc VARCHAR2(72) := g_package||'chk_co_formula_id';
441: l_accrual_formula ff_formulas_f.formula_name%TYPE;
442: l_co_formula ff_formulas_f.formula_name%TYPE;
443: l_api_updating BOOLEAN;
444:
445: BEGIN

Line 442: l_co_formula ff_formulas_f.formula_name%TYPE;

438: IS
439:
440: l_proc VARCHAR2(72) := g_package||'chk_co_formula_id';
441: l_accrual_formula ff_formulas_f.formula_name%TYPE;
442: l_co_formula ff_formulas_f.formula_name%TYPE;
443: l_api_updating BOOLEAN;
444:
445: BEGIN
446:

Line 733: l_accrual_formula ff_formulas_f.formula_name%TYPE;

729: ,p_check_accrual_ff OUT NOCOPY BOOLEAN)
730: IS
731:
732: l_proc VARCHAR2(72) := g_package||'chk_defined_balance_id';
733: l_accrual_formula ff_formulas_f.formula_name%TYPE;
734: l_api_updating BOOLEAN;
735: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
736: l_balance_type hr_organization_information.org_information1%TYPE;
737:

Line 1027: -- ff_formulas_f globally, for the business group or for the

1023: --
1024: -- NAME chk_ineligibility_formula_id
1025: --
1026: -- DESCRIPTION Validates that the ineligibility formula exists in
1027: -- ff_formulas_f globally, for the business group or for the
1028: -- legislation.
1029: --
1030: -- NOTES none
1031: --

Line 1041: l_ineligible_formula ff_formulas_f.formula_name%TYPE;

1037: ,p_ineligibility_formula_id IN NUMBER)
1038: IS
1039:
1040: l_proc VARCHAR2(72) := g_package||'chk_ineligibility_formula_id';
1041: l_ineligible_formula ff_formulas_f.formula_name%TYPE;
1042: l_api_updating BOOLEAN;
1043:
1044: BEGIN
1045: