APPS.BEN_PL_PRMRY_CARE_PRVDR_API dependencies on BEN_PL_PCP

Line 64: l_pl_pcp_id ben_pl_pcp.pl_pcp_id%TYPE;

60: ) is
61: --
62: -- Declare cursors and local variables
63: --
64: l_pl_pcp_id ben_pl_pcp.pl_pcp_id%TYPE;
65: l_proc varchar2(72) := g_package||'create_pl_prmry_care_prvdr';
66: l_object_version_number ben_pl_pcp.object_version_number%TYPE;
67: --
68: begin

Line 66: l_object_version_number ben_pl_pcp.object_version_number%TYPE;

62: -- Declare cursors and local variables
63: --
64: l_pl_pcp_id ben_pl_pcp.pl_pcp_id%TYPE;
65: l_proc varchar2(72) := g_package||'create_pl_prmry_care_prvdr';
66: l_object_version_number ben_pl_pcp.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 357: l_object_version_number ben_pl_pcp.object_version_number%TYPE;

353: --
354: -- Declare cursors and local variables
355: --
356: l_proc varchar2(72) := g_package||'update_pl_prmry_care_prvdr';
357: l_object_version_number ben_pl_pcp.object_version_number%TYPE;
358: --
359: begin
360: --
361: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 603: l_object_version_number ben_pl_pcp.object_version_number%TYPE;

599: --
600: -- Declare cursors and local variables
601: --
602: l_proc varchar2(72) := g_package||'update_pl_prmry_care_prvdr';
603: l_object_version_number ben_pl_pcp.object_version_number%TYPE;
604: --
605: begin
606: --
607: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 650: FROM ben_pl_pcp

646: UPDATE ben_oipl_f
647: SET pcp_dsgn_cd = NULL ,
648: pcp_dpnt_dsgn_cd = NULL
649: WHERE pl_id = ( SELECT pl_id
650: FROM ben_pl_pcp
651: WHERE pl_pcp_id = p_pl_pcp_id )
652: AND business_group_id = ( SELECT business_group_id
653: FROM ben_pl_pcp
654: WHERE pl_pcp_id = p_pl_pcp_id )

Line 653: FROM ben_pl_pcp

649: WHERE pl_id = ( SELECT pl_id
650: FROM ben_pl_pcp
651: WHERE pl_pcp_id = p_pl_pcp_id )
652: AND business_group_id = ( SELECT business_group_id
653: FROM ben_pl_pcp
654: WHERE pl_pcp_id = p_pl_pcp_id )
655: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
656:
657: end;