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 328: -- DESCRIPTION Validates that the accrual formula exists in ff_formulas_f

324: -- ----------------------------------------------------------------------------
325: --
326: -- NAME chk_accrual_formula_id
327: --
328: -- DESCRIPTION Validates that the accrual formula exists in ff_formulas_f
329: -- globally, for the business group or for the legislation.
330: --
331: -- NOTES none
332: --

Line 342: l_accrual_formula ff_formulas_f.formula_name%TYPE;

338: ,p_accrual_formula_id IN NUMBER)
339: IS
340:
341: l_proc VARCHAR2(72) := g_package||'chk_accrual_formula_id';
342: l_accrual_formula ff_formulas_f.formula_name%TYPE;
343: l_api_updating BOOLEAN;
344:
345: BEGIN
346:

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

396: -- ----------------------------------------------------------------------------
397: --
398: -- NAME chk_co_formula_id
399: --
400: -- DESCRIPTION Validates that the carry over formula exists in ff_formulas_f
401: -- globally, for the business group or for the legislation.
402: --
403: -- NOTES none
404: --

Line 415: l_accrual_formula ff_formulas_f.formula_name%TYPE;

411: ,p_co_formula_id IN NUMBER)
412: IS
413:
414: l_proc VARCHAR2(72) := g_package||'chk_co_formula_id';
415: l_accrual_formula ff_formulas_f.formula_name%TYPE;
416: l_co_formula ff_formulas_f.formula_name%TYPE;
417: l_api_updating BOOLEAN;
418:
419: BEGIN

Line 416: l_co_formula ff_formulas_f.formula_name%TYPE;

412: IS
413:
414: l_proc VARCHAR2(72) := g_package||'chk_co_formula_id';
415: l_accrual_formula ff_formulas_f.formula_name%TYPE;
416: l_co_formula ff_formulas_f.formula_name%TYPE;
417: l_api_updating BOOLEAN;
418:
419: BEGIN
420:

Line 707: l_accrual_formula ff_formulas_f.formula_name%TYPE;

703: ,p_check_accrual_ff OUT NOCOPY BOOLEAN)
704: IS
705:
706: l_proc VARCHAR2(72) := g_package||'chk_defined_balance_id';
707: l_accrual_formula ff_formulas_f.formula_name%TYPE;
708: l_api_updating BOOLEAN;
709: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
710: l_balance_type hr_organization_information.org_information1%TYPE;
711:

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

997: --
998: -- NAME chk_ineligibility_formula_id
999: --
1000: -- DESCRIPTION Validates that the ineligibility formula exists in
1001: -- ff_formulas_f globally, for the business group or for the
1002: -- legislation.
1003: --
1004: -- NOTES none
1005: --

Line 1015: l_ineligible_formula ff_formulas_f.formula_name%TYPE;

1011: ,p_ineligibility_formula_id IN NUMBER)
1012: IS
1013:
1014: l_proc VARCHAR2(72) := g_package||'chk_ineligibility_formula_id';
1015: l_ineligible_formula ff_formulas_f.formula_name%TYPE;
1016: l_api_updating BOOLEAN;
1017:
1018: BEGIN
1019: