DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on GHR_CPDF_DYNRPT

Line 534: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN

530: EXIT WHEN SF113_SECTION1%NOTFOUND;
531: l_susp_flag := 'N';
532:
533: -- Exclude NAF positions (Non-Apropriated Fund Positions) using CPDF dynamics function
534: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN
535: l_duty_station := hr_api.g_varchar2;
536:
537: IF l_duty_station_code in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
538: 'RM','HQ','PS','BQ','WQ','VQ') THEN

Line 1214: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN

1210: -- Below Condition have been moved from cursor to here, to improve performance.
1211: IF (l_pa_system_status = 'ACTIVE_ASSIGN') OR (l_pa_system_status = 'TERM_ASSIGN' AND l_pa_effective_start_date = p_rpt_date) THEN
1212:
1213: -- Exclude NAF positions (Non-Apropriated Fund Positions) using CPDF dynamics function
1214: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN
1215:
1216: l_duty_station := hr_api.g_varchar2;
1217: IF l_duty_station_code in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
1218: 'RM','HQ','PS','BQ','WQ','VQ') THEN

Line 1629: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN

1625:
1626:
1627: -- Exclude NAF positions (Non-Appropriate Fund positions)
1628:
1629: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN
1630:
1631: l_duty_station := hr_api.g_varchar2;
1632:
1633: -- Bug 3264666

Line 1773: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN

1769:
1770: EXIT WHEN sf113_section3%NOTFOUND;
1771:
1772: -- Exclude NAF positions (Non-Appropriate Fund positions)
1773: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN
1774:
1775: l_duty_station := hr_api.g_varchar2;
1776:
1777: IF l_duty_station_code in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',