APPS.PAY_NL_LSS_FUNCTIONS dependencies on FND_NUMBER

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 588: l_current_year number := fnd_number.canonical_to_number(to_char(p_date_earned,'YYYY'));

584: p_lcld_limit IN OUT NOCOPY NUMBER,
585: p_error_msg IN OUT NOCOPY VARCHAR2)
586: RETURN NUMBER IS
587:
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;

Line 614: and p_year between fnd_number.canonical_to_number(to_char(EFFECTIVE_START_DATE,'YYYY'))

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'));
616:
617: CURSOR csr_get_def_bal_type_id
618: (c_balance_name VARCHAR2

Line 615: and fnd_number.canonical_to_number(to_char(EFFECTIVE_END_DATE,'YYYY'));

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'));
616:
617: CURSOR csr_get_def_bal_type_id
618: (c_balance_name VARCHAR2
619: ,c_dimension_name VARCHAR2) IS

Line 648: l_gbl_value := fnd_number.canonical_to_number(l_gbl_value_temp);

644: close c_gbl_value;
645:
646: hr_utility.set_location('l_gbl_value_temp: '||l_gbl_value_temp, 1200);
647:
648: l_gbl_value := fnd_number.canonical_to_number(l_gbl_value_temp);
649:
650: hr_utility.set_location('l_gbl_value: '||l_gbl_value, 800);
651:
652: l_lcld_limit := p_num_saved_yrs * l_gbl_value;