DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on HR_AU_ROUTES

Line 1446: l_fin_year_start := hr_au_routes.span_start(p_retro_effective_date,1,'01-07');

1442: OPEN get_retropay_run_details(p_element_entry_id);
1443: FETCH get_retropay_run_details INTO l_creator_type,p_retro_effective_date;
1444: CLOSE get_retropay_run_details;
1445:
1446: l_fin_year_start := hr_au_routes.span_start(p_retro_effective_date,1,'01-07');
1447: l_month_start := hr_au_routes.span_start(p_retro_effective_date,12,'01-01');
1448:
1449: IF l_creator_type = 'RR'
1450: THEN

Line 1447: l_month_start := hr_au_routes.span_start(p_retro_effective_date,12,'01-01');

1443: FETCH get_retropay_run_details INTO l_creator_type,p_retro_effective_date;
1444: CLOSE get_retropay_run_details;
1445:
1446: l_fin_year_start := hr_au_routes.span_start(p_retro_effective_date,1,'01-07');
1447: l_month_start := hr_au_routes.span_start(p_retro_effective_date,12,'01-01');
1448:
1449: IF l_creator_type = 'RR'
1450: THEN
1451: OPEN get_retro_period_rr(p_element_entry_id,p_date_earned);

Line 1455: l_orig_month_start := hr_au_routes.span_start(p_orig_effective_date,12,'01-01');

1451: OPEN get_retro_period_rr(p_element_entry_id,p_date_earned);
1452: FETCH get_retro_period_rr INTO p_retro_start_date,p_retro_end_date,p_orig_effective_date;
1453: IF get_retro_period_rr%FOUND
1454: THEN
1455: l_orig_month_start := hr_au_routes.span_start(p_orig_effective_date,12,'01-01');
1456: l_period_obtained_flag:=1;
1457: END IF;
1458: CLOSE get_retro_period_rr;
1459: END IF;

Line 1466: l_orig_month_start := hr_au_routes.span_start(p_orig_effective_date,12,'01-01');

1462: OPEN get_retro_period_ee(p_element_entry_id,p_date_earned);
1463: FETCH get_retro_period_ee INTO p_retro_start_date,p_retro_end_date,p_orig_effective_date;
1464: IF get_retro_period_ee%FOUND
1465: THEN
1466: l_orig_month_start := hr_au_routes.span_start(p_orig_effective_date,12,'01-01');
1467: l_period_obtained_flag:=1;
1468: END IF;
1469: CLOSE get_retro_period_ee;
1470: END IF;

Line 1680: l_fin_year_start := hr_au_routes.span_start(p_date_earned,1,'01-07');

1676: IF l_retro_period > 12
1677: THEN
1678: p_time_span := 'GT12';
1679: ELSE
1680: l_fin_year_start := hr_au_routes.span_start(p_date_earned,1,'01-07');
1681: IF p_retro_end_date < l_fin_year_start
1682: THEN
1683: p_time_span := 'LT12 Prev';
1684: ELSE

Line 1829: financial_year_span_start:=hr_au_routes.span_start(p_date_earned,1,'01-07');

1825: hr_utility.set_location('Enhanced Retropay Rule Value =>'||l_adv_retro_flag,50);
1826: END IF;
1827:
1828: l_retro_periods:=0;
1829: financial_year_span_start:=hr_au_routes.span_start(p_date_earned,1,'01-07');
1830:
1831: /* Bug 6139035 - Get Financial Year Information based on Effective Date of run */
1832: OPEN c_get_effective_date(p_assignment_action_id);
1833: FETCH c_get_effective_date INTO l_pay_effective_date;

Line 1836: l_eff_date_yr_start := hr_au_routes.span_start(l_pay_effective_date,1,'01-07');

1832: OPEN c_get_effective_date(p_assignment_action_id);
1833: FETCH c_get_effective_date INTO l_pay_effective_date;
1834: CLOSE c_get_effective_date;
1835:
1836: l_eff_date_yr_start := hr_au_routes.span_start(l_pay_effective_date,1,'01-07');
1837:
1838: for process_element in get_element_entries
1839: loop
1840: /* Bug 5846272 - Use Existing Logic if Enh Retro Rule is 'N' ELSE