DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on HR_AU_ROUTES

Line 2325: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');

2321: open csr_get_curr_atd;
2322: fetch csr_get_curr_atd into l_acutal_termination_date;
2323: close csr_get_curr_atd;
2324:
2325: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');
2326: l_year_end_atd := add_months(l_year_start_atd,12) - 1;
2327: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
2328: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
2329:

Line 2327: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');

2323: close csr_get_curr_atd;
2324:
2325: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');
2326: l_year_end_atd := add_months(l_year_start_atd,12) - 1;
2327: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
2328: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
2329:
2330: IF g_debug THEN
2331: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);

Line 2728: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');

2724: open csr_get_curr_atd;
2725: fetch csr_get_curr_atd into l_acutal_termination_date;
2726: close csr_get_curr_atd;
2727:
2728: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');
2729: l_year_end_atd := add_months(l_year_start_atd,12) - 1;
2730: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
2731: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
2732:

Line 2730: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');

2726: close csr_get_curr_atd;
2727:
2728: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');
2729: l_year_end_atd := add_months(l_year_start_atd,12) - 1;
2730: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
2731: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
2732:
2733: IF g_debug THEN
2734: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 30);

Line 3472: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');

3468: open csr_get_curr_atd;
3469: fetch csr_get_curr_atd into l_acutal_termination_date;
3470: close csr_get_curr_atd;
3471:
3472: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');
3473: l_year_end_atd := add_months(l_year_start_atd,12) - 1;
3474: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
3475: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
3476:

Line 3474: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');

3470: close csr_get_curr_atd;
3471:
3472: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');
3473: l_year_end_atd := add_months(l_year_start_atd,12) - 1;
3474: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
3475: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
3476:
3477: IF g_debug THEN
3478: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);

Line 3988: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');

3984: open csr_get_curr_atd;
3985: fetch csr_get_curr_atd into l_acutal_termination_date;
3986: close csr_get_curr_atd;
3987:
3988: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');
3989: l_year_end_atd := add_months(l_year_start_atd,12) - 1;
3990: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
3991: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
3992:

Line 3990: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');

3986: close csr_get_curr_atd;
3987:
3988: l_year_start_atd := hr_au_routes.span_start(l_acutal_termination_date, 1, '01-07-');
3989: l_year_end_atd := add_months(l_year_start_atd,12) - 1;
3990: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
3991: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
3992:
3993: IF g_debug THEN
3994: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 31);