APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 5929: from ben_prmry_care_prvdr_f pcp

5925: ,pcp.EFFECTIVE_END_DATE
5926: ,pcp.PRTT_ENRT_RSLT_ID
5927: ,pcp.BUSINESS_GROUP_ID
5928: ,pcp.OBJECT_VERSION_NUMBER
5929: from ben_prmry_care_prvdr_f pcp
5930: where pcp.business_group_id = p_business_group_id
5931: and pcp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5932: and p_effective_date between pcp.effective_start_date
5933: and pcp.effective_end_date

Line 5945: from ben_prmry_care_prvdr_f pcp

5941: ,pcp.EFFECTIVE_END_DATE
5942: ,pcp.PRTT_ENRT_RSLT_ID
5943: ,pcp.BUSINESS_GROUP_ID
5944: ,pcp.OBJECT_VERSION_NUMBER
5945: from ben_prmry_care_prvdr_f pcp
5946: where pcp.business_group_id = p_business_group_id
5947: and pcp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5948: and p_effective_date < pcp.effective_start_date
5949: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot

Line 6586: from ben_prmry_care_prvdr_f pcp

6582: ,pcp.EFFECTIVE_END_DATE
6583: ,pcp.PRTT_ENRT_RSLT_ID
6584: ,pcp.BUSINESS_GROUP_ID
6585: ,pcp.OBJECT_VERSION_NUMBER
6586: from ben_prmry_care_prvdr_f pcp
6587: where business_group_id = p_business_group_id
6588: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6589: and c_pcp_effective_date between effective_start_date --3631067: Changed p_effective_date to c_pcp_effective_date
6590: and effective_end_date

Line 6602: from ben_prmry_care_prvdr_f pcp

6598: ,pcp.EFFECTIVE_END_DATE
6599: ,pcp.PRTT_ENRT_RSLT_ID
6600: ,pcp.BUSINESS_GROUP_ID
6601: ,pcp.OBJECT_VERSION_NUMBER
6602: from ben_prmry_care_prvdr_f pcp
6603: where business_group_id = p_business_group_id
6604: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6605: and c_pcp_effective_date < effective_start_date ----3631067: Changed p_effective_date to c_pcp_effective_date
6606: and NVL(effective_end_date, hr_api.g_eot) = hr_api.g_eot

Line 11031: from ben_prmry_care_prvdr_f pcp

11027: ,pcp.EFFECTIVE_END_DATE
11028: ,pcp.PRTT_ENRT_RSLT_ID
11029: ,pcp.BUSINESS_GROUP_ID
11030: ,pcp.OBJECT_VERSION_NUMBER
11031: from ben_prmry_care_prvdr_f pcp
11032: where business_group_id = p_business_group_id
11033: and elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
11034: and p_effective_date between effective_start_date
11035: and effective_end_date

Line 11047: from ben_prmry_care_prvdr_f pcp

11043: ,pcp.EFFECTIVE_END_DATE
11044: ,pcp.PRTT_ENRT_RSLT_ID
11045: ,pcp.BUSINESS_GROUP_ID
11046: ,pcp.OBJECT_VERSION_NUMBER
11047: from ben_prmry_care_prvdr_f pcp
11048: where pcp.business_group_id = p_business_group_id
11049: and pcp.elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
11050: and p_effective_date < pcp.effective_start_date
11051: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot