APPS.PQH_DE_GRADE_COMPUTE dependencies on PQH_DE_WRKPLC_VLDTN_OPS

Line 12: from PQH_DE_WRKPLC_VLDTN_OPS a, PQH_DE_WRKPLC_VLDTN_Jobftrs b Where

8: P_Wc_Case_group Out NOCOPY Varchar2) is
9:
10: Cursor Jobftr_Unitperc is
11: Select Sum(Nvl(Unit_Percentage,0)) Untperc , Job_Feature_Code
12: from PQH_DE_WRKPLC_VLDTN_OPS a, PQH_DE_WRKPLC_VLDTN_Jobftrs b Where
13: WRKPLC_VLDTN_VER_ID = p_Wrkplc_Vldtn_Ver_Id and
14: a.Business_group_Id = p_Business_Group_Id and
15: a.WRKPLC_VLDTN_OP_ID = WRKPLC_VLDTN_OPR_JOB_ID and
16: WRKPLC_VLDTN_OPR_JOB_TYPE = 'O' and

Line 46: l_UntPerct Pqh_de_wrkplc_Vldtn_Ops.Unit_Percentage%TYPE;

42: and b.HIERARCHY_NODE_ID = a.PARENT_HIERARCHY_NODE_ID
43: and b.Hierarchy_Version_Id = a.Hierarchy_Version_Id;
44:
45: l_Grade_Status Varchar2(1) := 'N';
46: l_UntPerct Pqh_de_wrkplc_Vldtn_Ops.Unit_Percentage%TYPE;
47: Begin
48: P_WC_Grade := -4;
49: Select Nvl(Sum(Unit_Percentage),0) into l_UntPerct
50: From Pqh_de_wrkplc_Vldtn_Ops

Line 50: From Pqh_de_wrkplc_Vldtn_Ops

46: l_UntPerct Pqh_de_wrkplc_Vldtn_Ops.Unit_Percentage%TYPE;
47: Begin
48: P_WC_Grade := -4;
49: Select Nvl(Sum(Unit_Percentage),0) into l_UntPerct
50: From Pqh_de_wrkplc_Vldtn_Ops
51: Where Wrkplc_Vldtn_Ver_Id = p_Wrkplc_Vldtn_Ver_Id;
52: If l_UntPerct <> 100 Then
53: P_WC_Grade := -1;
54: Return;