DBA Data[Home] [Help]

APPS.PAY_NL_SI_PKG dependencies on FF_FORMULAS_F

Line 8: g_ptp_formula_id ff_formulas_f.formula_id%TYPE;

4: g_legislation_code varchar2(2) :='NL';
5: g_udt_name VARCHAR2(50) := 'PQP_COMPANY_WORK_PATTERNS';
6: g_ptp_formula_exists BOOLEAN := TRUE;
7: g_ptp_formula_cached BOOLEAN := FALSE;
8: g_ptp_formula_id ff_formulas_f.formula_id%TYPE;
9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;
10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;

Line 9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;

5: g_udt_name VARCHAR2(50) := 'PQP_COMPANY_WORK_PATTERNS';
6: g_ptp_formula_exists BOOLEAN := TRUE;
7: g_ptp_formula_cached BOOLEAN := FALSE;
8: g_ptp_formula_id ff_formulas_f.formula_id%TYPE;
9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;
10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;
13: g_std_ptp_formula_id ff_formulas_f.formula_id%TYPE;

Line 13: g_std_ptp_formula_id ff_formulas_f.formula_id%TYPE;

9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;
10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;
13: g_std_ptp_formula_id ff_formulas_f.formula_id%TYPE;
14: g_std_ptp_formula_name ff_formulas_f.formula_name%TYPE;
15: /* Global Variables for Pseudo SI Part Time Percentage */
16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;

Line 14: g_std_ptp_formula_name ff_formulas_f.formula_name%TYPE;

10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;
13: g_std_ptp_formula_id ff_formulas_f.formula_id%TYPE;
14: g_std_ptp_formula_name ff_formulas_f.formula_name%TYPE;
15: /* Global Variables for Pseudo SI Part Time Percentage */
16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;
18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;

Line 18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;

14: g_std_ptp_formula_name ff_formulas_f.formula_name%TYPE;
15: /* Global Variables for Pseudo SI Part Time Percentage */
16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;
18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;
19: g_pse_ptp_formula_name ff_formulas_f.formula_name%TYPE;
20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;

Line 19: g_pse_ptp_formula_name ff_formulas_f.formula_name%TYPE;

15: /* Global Variables for Pseudo SI Part Time Percentage */
16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;
18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;
19: g_pse_ptp_formula_name ff_formulas_f.formula_name%TYPE;
20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;
23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;

Line 23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;

19: g_pse_ptp_formula_name ff_formulas_f.formula_name%TYPE;
20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;
23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
24: g_std_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
25: /* Global variables for Override Real SI Days */
26: g_real_si_days_formula_exists BOOLEAN := TRUE;
27: g_real_si_days_formula_cached BOOLEAN := FALSE;

Line 24: g_std_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;

20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;
23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
24: g_std_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
25: /* Global variables for Override Real SI Days */
26: g_real_si_days_formula_exists BOOLEAN := TRUE;
27: g_real_si_days_formula_cached BOOLEAN := FALSE;
28: g_real_si_days_formula_id ff_formulas_f.formula_id%TYPE;

Line 28: g_real_si_days_formula_id ff_formulas_f.formula_id%TYPE;

24: g_std_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
25: /* Global variables for Override Real SI Days */
26: g_real_si_days_formula_exists BOOLEAN := TRUE;
27: g_real_si_days_formula_cached BOOLEAN := FALSE;
28: g_real_si_days_formula_id ff_formulas_f.formula_id%TYPE;
29: g_real_si_days_formula_name ff_formulas_f.formula_name%TYPE;
30: /* Global Variables for Pseudo SI Reporting Part Time Percentage */
31: g_pse_rep_ptp_formula_exists BOOLEAN := TRUE;
32: g_pse_rep_ptp_formula_cached BOOLEAN := FALSE;

Line 29: g_real_si_days_formula_name ff_formulas_f.formula_name%TYPE;

25: /* Global variables for Override Real SI Days */
26: g_real_si_days_formula_exists BOOLEAN := TRUE;
27: g_real_si_days_formula_cached BOOLEAN := FALSE;
28: g_real_si_days_formula_id ff_formulas_f.formula_id%TYPE;
29: g_real_si_days_formula_name ff_formulas_f.formula_name%TYPE;
30: /* Global Variables for Pseudo SI Reporting Part Time Percentage */
31: g_pse_rep_ptp_formula_exists BOOLEAN := TRUE;
32: g_pse_rep_ptp_formula_cached BOOLEAN := FALSE;
33: g_pse_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;

Line 33: g_pse_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;

29: g_real_si_days_formula_name ff_formulas_f.formula_name%TYPE;
30: /* Global Variables for Pseudo SI Reporting Part Time Percentage */
31: g_pse_rep_ptp_formula_exists BOOLEAN := TRUE;
32: g_pse_rep_ptp_formula_cached BOOLEAN := FALSE;
33: g_pse_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
34: g_pse_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
35: /* Global Variables for Override SI Days */
36: g_si_days_formula_exists BOOLEAN := TRUE;
37: g_si_days_formula_cached BOOLEAN := FALSE;

Line 34: g_pse_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;

30: /* Global Variables for Pseudo SI Reporting Part Time Percentage */
31: g_pse_rep_ptp_formula_exists BOOLEAN := TRUE;
32: g_pse_rep_ptp_formula_cached BOOLEAN := FALSE;
33: g_pse_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
34: g_pse_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
35: /* Global Variables for Override SI Days */
36: g_si_days_formula_exists BOOLEAN := TRUE;
37: g_si_days_formula_cached BOOLEAN := FALSE;
38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;

Line 38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;

34: g_pse_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
35: /* Global Variables for Override SI Days */
36: g_si_days_formula_exists BOOLEAN := TRUE;
37: g_si_days_formula_cached BOOLEAN := FALSE;
38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;
39: g_si_days_formula_name ff_formulas_f.formula_name%TYPE;
40: g_si_days NUMBER;
41: /* Global Variables for Override SI Days ZVW */
42: g_si_days_zvw NUMBER;

Line 39: g_si_days_formula_name ff_formulas_f.formula_name%TYPE;

35: /* Global Variables for Override SI Days */
36: g_si_days_formula_exists BOOLEAN := TRUE;
37: g_si_days_formula_cached BOOLEAN := FALSE;
38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;
39: g_si_days_formula_name ff_formulas_f.formula_name%TYPE;
40: g_si_days NUMBER;
41: /* Global Variables for Override SI Days ZVW */
42: g_si_days_zvw NUMBER;
43: /* Global Variables for Tax Proration Days */

Line 559: l_formula_id ff_formulas_f.formula_id%TYPE;

555: l_inputs ff_exec.inputs_t;
556: l_outputs ff_exec.outputs_t;
557: l_formula_exists BOOLEAN := TRUE;
558: l_formula_cached BOOLEAN := FALSE;
559: l_formula_id ff_formulas_f.formula_id%TYPE;
560: BEGIN
561: g_ptp_formula_name := 'NL_PART_TIME_PERCENTAGE';
562: --
563: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 632: l_formula_id ff_formulas_f.formula_id%TYPE;

628: l_inputs ff_exec.inputs_t;
629: l_outputs ff_exec.outputs_t;
630: l_formula_exists BOOLEAN := TRUE;
631: l_formula_cached BOOLEAN := FALSE;
632: l_formula_id ff_formulas_f.formula_id%TYPE;
633: BEGIN
634: g_std_ptp_formula_name := 'NL_STANDARD_SI_PART_TIME_PERCENTAGE';
635: --
636: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 706: l_formula_id ff_formulas_f.formula_id%TYPE;

702: l_inputs ff_exec.inputs_t;
703: l_outputs ff_exec.outputs_t;
704: l_formula_exists BOOLEAN := TRUE;
705: l_formula_cached BOOLEAN := FALSE;
706: l_formula_id ff_formulas_f.formula_id%TYPE;
707: BEGIN
708: g_pse_ptp_formula_name := 'NL_PSEUDO_SI_PART_TIME_PERCENTAGE';
709: --
710: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 780: l_formula_id ff_formulas_f.formula_id%TYPE;

776: l_inputs ff_exec.inputs_t;
777: l_outputs ff_exec.outputs_t;
778: l_formula_exists BOOLEAN := TRUE;
779: l_formula_cached BOOLEAN := FALSE;
780: l_formula_id ff_formulas_f.formula_id%TYPE;
781: BEGIN
782: g_std_rep_ptp_formula_name := 'NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
783: --
784: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 853: l_formula_id ff_formulas_f.formula_id%TYPE;

849: l_inputs ff_exec.inputs_t;
850: l_outputs ff_exec.outputs_t;
851: l_formula_exists BOOLEAN := TRUE;
852: l_formula_cached BOOLEAN := FALSE;
853: l_formula_id ff_formulas_f.formula_id%TYPE;
854: BEGIN
855: g_pse_rep_ptp_formula_name := 'NL_PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE';
856: --
857: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 1004: l_formula_id ff_formulas_f.formula_id%TYPE;

1000: l_inputs ff_exec.inputs_t;
1001: l_outputs ff_exec.outputs_t;
1002: l_formula_exists BOOLEAN := TRUE;
1003: l_formula_cached BOOLEAN := FALSE;
1004: l_formula_id ff_formulas_f.formula_id%TYPE;
1005: BEGIN
1006: g_real_si_days_formula_name := 'NL_REAL_SOCIAL_INSURANCE_DAYS';
1007: IF g_real_si_days_formula_exists = TRUE THEN
1008: IF g_real_si_days_formula_cached = FALSE THEN

Line 1745: l_formula_id ff_formulas_f.formula_id%TYPE;

1741: l_inputs ff_exec.inputs_t;
1742: l_outputs ff_exec.outputs_t;
1743: l_formula_exists BOOLEAN := TRUE;
1744: l_formula_cached BOOLEAN := FALSE;
1745: l_formula_id ff_formulas_f.formula_id%TYPE;
1746: BEGIN
1747: g_si_days_formula_name := 'NL_OVERRIDE_SOCIAL_INSURANCE_DAYS';
1748: IF g_si_days_formula_exists = TRUE THEN
1749: IF g_si_days_formula_cached = FALSE THEN