APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 5640: from ben_prmry_care_prvdr_f pcp

5636: ,pcp.EFFECTIVE_END_DATE
5637: ,pcp.PRTT_ENRT_RSLT_ID
5638: ,pcp.BUSINESS_GROUP_ID
5639: ,pcp.OBJECT_VERSION_NUMBER
5640: from ben_prmry_care_prvdr_f pcp
5641: where pcp.business_group_id = p_business_group_id
5642: and pcp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5643: and p_effective_date between pcp.effective_start_date
5644: and pcp.effective_end_date

Line 5656: from ben_prmry_care_prvdr_f pcp

5652: ,pcp.EFFECTIVE_END_DATE
5653: ,pcp.PRTT_ENRT_RSLT_ID
5654: ,pcp.BUSINESS_GROUP_ID
5655: ,pcp.OBJECT_VERSION_NUMBER
5656: from ben_prmry_care_prvdr_f pcp
5657: where pcp.business_group_id = p_business_group_id
5658: and pcp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5659: and p_effective_date < pcp.effective_start_date
5660: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot

Line 6335: from ben_prmry_care_prvdr_f pcp

6331: ,pcp.EFFECTIVE_END_DATE
6332: ,pcp.PRTT_ENRT_RSLT_ID
6333: ,pcp.BUSINESS_GROUP_ID
6334: ,pcp.OBJECT_VERSION_NUMBER
6335: from ben_prmry_care_prvdr_f pcp
6336: where business_group_id = p_business_group_id
6337: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6338: and c_pcp_effective_date between effective_start_date --3631067: Changed p_effective_date to c_pcp_effective_date
6339: and effective_end_date

Line 6351: from ben_prmry_care_prvdr_f pcp

6347: ,pcp.EFFECTIVE_END_DATE
6348: ,pcp.PRTT_ENRT_RSLT_ID
6349: ,pcp.BUSINESS_GROUP_ID
6350: ,pcp.OBJECT_VERSION_NUMBER
6351: from ben_prmry_care_prvdr_f pcp
6352: where business_group_id = p_business_group_id
6353: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6354: and c_pcp_effective_date < effective_start_date ----3631067: Changed p_effective_date to c_pcp_effective_date
6355: and NVL(effective_end_date, hr_api.g_eot) = hr_api.g_eot

Line 9437: from ben_prmry_care_prvdr_f pcp

9433: ,pcp.EFFECTIVE_END_DATE
9434: ,pcp.PRTT_ENRT_RSLT_ID
9435: ,pcp.BUSINESS_GROUP_ID
9436: ,pcp.OBJECT_VERSION_NUMBER
9437: from ben_prmry_care_prvdr_f pcp
9438: where business_group_id = p_business_group_id
9439: and elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
9440: and p_effective_date between effective_start_date
9441: and effective_end_date

Line 9453: from ben_prmry_care_prvdr_f pcp

9449: ,pcp.EFFECTIVE_END_DATE
9450: ,pcp.PRTT_ENRT_RSLT_ID
9451: ,pcp.BUSINESS_GROUP_ID
9452: ,pcp.OBJECT_VERSION_NUMBER
9453: from ben_prmry_care_prvdr_f pcp
9454: where pcp.business_group_id = p_business_group_id
9455: and pcp.elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
9456: and p_effective_date < pcp.effective_start_date
9457: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot