DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on FND_DATE

Line 2806: ,fnd_date.date_to_canonical( prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ ) RDate

2802: ,p_element_name VARCHAR2
2803: ,p_input_value_name VARCHAR2
2804: ,p_date_earned DATE) IS
2805: SELECT prv.result_value value
2806: ,fnd_date.date_to_canonical( prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ ) RDate
2807: ,pet.element_type_id element_type_id
2808: ,pet.element_name element_name
2809: ,nvl(pettl.reporting_name,pettl.element_name) reporting_name
2810: ,pet.processing_priority priority

Line 3437: l_date:=fnd_date.date_to_canonical(l_element_retro_entries(i));

3433:
3434: l_priority:=retro_element_value_rec.priority;
3435: l_reporting_name:=retro_element_value_rec.reporting_name;
3436:
3437: l_date:=fnd_date.date_to_canonical(l_element_retro_entries(i));
3438:
3439: --
3440: END LOOP;
3441:

Line 5008: l_date:=fnd_date.date_to_canonical(l_element_retro_entries(i));

5004: --hr_utility.set_location('Inside archive_retro_balance_info l_balance_name'||l_balance_name,5150);
5005:
5006: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_balance_name'||' '||l_balance_name);
5007:
5008: l_date:=fnd_date.date_to_canonical(l_element_retro_entries(i));
5009: --Bug No. 3384315
5010: --Fetch the si type name for the p_balance_name
5011: IF l_si_type IS NULL THEN
5012: OPEN csr_retro_values(csr_np_rec.np_assignment_action_id,p_balance_name

Line 5383: l_date:=fnd_date.date_to_canonical(l_element_retro_entries(i));

5379: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_ptd'||' '||l_sum_ptd);
5380: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_element_retro_entries(i)'||' '||l_element_retro_entries(i));
5381: /*Commented codde to fix bug 4035406 - Retro period not displayed for Employee IZA contributions*/
5382: /*IF l_sum_ptd <>0 THEN*/
5383: l_date:=fnd_date.date_to_canonical(l_element_retro_entries(i));
5384: /*END IF;*/
5385: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_date'||' '||l_date);
5386: --
5387: END LOOP;