APPS.PAY_NL_LSS_FUNCTIONS dependencies on FF_GLOBALS_F

Line 124: SELECT global_name g_name, fnd_number.canonical_to_number(global_value) g_val FROM FF_GLOBALS_F

120:
121:
122: /* Cursor to access Global vlaues for Wage days in a pay_period depanding on Payroll Type. */
123: CURSOR csr_globals_nl_average_days IS
124: SELECT global_name g_name, fnd_number.canonical_to_number(global_value) g_val FROM FF_GLOBALS_F
125: WHERE legislation_code = 'NL' AND
126: global_name in ('NL_AVERAGE_DAYS_WEEKLY', 'NL_AVERAGE_DAYS_4WEEKLY', 'NL_AVERAGE_DAYS_MONTHLY',
127: 'NL_AVERAGE_DAYS_QUARTERLY') AND
128: (EFFECTIVE_START_DATE <= p_application_date and EFFECTIVE_END_DATE >= p_application_date);

Line 592: l_gbl_value_temp ff_globals_f.GLOBAL_VALUE%TYPE;

588: l_current_year number := fnd_number.canonical_to_number(to_char(p_date_earned,'YYYY'));
589: l_num_saved_yrs number := p_num_saved_yrs;
590: l_lcld_limit number := 0;
591: l_gbl_value number := 0;
592: l_gbl_value_temp ff_globals_f.GLOBAL_VALUE%TYPE;
593: l_balance_amount NUMBER := 0;
594: l_lss_ytd number := 0;
595: l_date date;
596: l_per_ytd VARCHAR2(100) := 'Person Year to Date';

Line 611: select GLOBAL_VALUE from ff_globals_f

607: OR to_char(effective_end_date,'YYYY') = p_year);
608:
609:
610: Cursor c_gbl_value(p_year number) is
611: select GLOBAL_VALUE from ff_globals_f
612: where global_name = 'PAY_NL_MAX_LCLD_PER_YEAR'
613: and legislation_code = 'NL'
614: and p_year between fnd_number.canonical_to_number(to_char(EFFECTIVE_START_DATE,'YYYY'))
615: and fnd_number.canonical_to_number(to_char(EFFECTIVE_END_DATE,'YYYY'));