DBA Data[Home] [Help]

APPS.PQH_DE_VLD_NEWVER_DEL dependencies on PQH_DE_WRKPLC_VLDTN_JOBFTRS

Line 13: l_Jobftr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_JobFtrs.object_Version_Number%TYPE;

9: l_Opr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Ops.object_Version_Number%TYPE;
10: l_Wrkplc_Vldtn_Op_Id Pqh_De_Wrkplc_Vldtn_Ops.Wrkplc_Vldtn_Op_Id%TYPE;
11: l_Job_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Jobs.object_Version_Number%TYPE;
12: l_Wrkplc_Vldtn_Job_Id Pqh_De_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_JOb_Id%TYPE;
13: l_Jobftr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_JobFtrs.object_Version_Number%TYPE;
14: l_Wrkplc_Vldtn_JobFTr_Id Pqh_De_Wrkplc_Vldtn_JobFTRS.Wrkplc_Vldtn_JObFTr_Id%TYPE;
15: l_WRKPLC_VLDTN_LVLNUM_Id Pqh_de_Wrkplc_Vldtn_Lvlnums.WRKPLC_VLDTN_LVLNUM_Id%TYPE;
16: l_Lvlnum_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Lvlnums.object_Version_Number%TYPE;
17:

Line 14: l_Wrkplc_Vldtn_JobFTr_Id Pqh_De_Wrkplc_Vldtn_JobFTRS.Wrkplc_Vldtn_JObFTr_Id%TYPE;

10: l_Wrkplc_Vldtn_Op_Id Pqh_De_Wrkplc_Vldtn_Ops.Wrkplc_Vldtn_Op_Id%TYPE;
11: l_Job_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Jobs.object_Version_Number%TYPE;
12: l_Wrkplc_Vldtn_Job_Id Pqh_De_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_JOb_Id%TYPE;
13: l_Jobftr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_JobFtrs.object_Version_Number%TYPE;
14: l_Wrkplc_Vldtn_JobFTr_Id Pqh_De_Wrkplc_Vldtn_JobFTRS.Wrkplc_Vldtn_JObFTr_Id%TYPE;
15: l_WRKPLC_VLDTN_LVLNUM_Id Pqh_de_Wrkplc_Vldtn_Lvlnums.WRKPLC_VLDTN_LVLNUM_Id%TYPE;
16: l_Lvlnum_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Lvlnums.object_Version_Number%TYPE;
17:
18:

Line 44: From PQH_DE_WRKPLC_VLDTN_JOBFTRS

40: Business_Group_Id = p_Business_Group_Id;
41:
42: Cursor Wrkplc_Vldtn_JobFtrs (P_Wrkplc_Vldtn_OpJob_Id In Number,P_Wrkplc_Vldtn_OprJob_Type In Varchar2) is
43: Select WRKPLC_VLDTN_JOBFTR_ID, JOB_FEATURE_CODE
44: From PQH_DE_WRKPLC_VLDTN_JOBFTRS
45: Where WRKPLC_VLDTN_OPR_JOB_TYPE = P_Wrkplc_Vldtn_OprJob_Type and
46: WRKPLC_VLDTN_OPR_JOB_ID = P_Wrkplc_Vldtn_OpJob_Id and
47: Business_group_id = p_Business_group_id;
48:

Line 179: From PQH_DE_WRKPLC_VLDTN_JOBFTRS

175: Business_Group_Id = p_Business_Group_Id;
176:
177: Cursor Wrkplc_Vldtn_JobFtrs (P_Wrkplc_Vldtn_OpJob_Id In Number,P_Wrkplc_Vldtn_OprJob_Type In Varchar2) is
178: Select WRKPLC_VLDTN_JOBFTR_ID, JOB_FEATURE_CODE, Object_Version_Number
179: From PQH_DE_WRKPLC_VLDTN_JOBFTRS
180: Where WRKPLC_VLDTN_OPR_JOB_TYPE = P_Wrkplc_Vldtn_OprJob_Type and
181: WRKPLC_VLDTN_OPR_JOB_ID = P_Wrkplc_Vldtn_OpJob_Id and
182: Business_group_id = p_Business_group_id;
183:

Line 286: From PQH_DE_WRKPLC_VLDTN_JOBFTRS

282: Business_Group_Id = p_Business_Group_Id;
283:
284: Cursor Wrkplc_Vldtn_JobFtrs (P_Wrkplc_Vldtn_OpJob_Id In Number,P_Wrkplc_Vldtn_OprJob_Type In Varchar2) is
285: Select WRKPLC_VLDTN_JOBFTR_ID, JOB_FEATURE_CODE, Object_Version_Number
286: From PQH_DE_WRKPLC_VLDTN_JOBFTRS
287: Where WRKPLC_VLDTN_OPR_JOB_TYPE = P_Wrkplc_Vldtn_OprJob_Type and
288: WRKPLC_VLDTN_OPR_JOB_ID = P_Wrkplc_Vldtn_OpJob_Id and
289: Business_group_id = p_Business_group_id;
290:

Line 338: From PQH_DE_WRKPLC_VLDTN_JOBFTRS

334: Business_Group_Id = p_Business_Group_Id;
335:
336: Cursor Wrkplc_Vldtn_JobFtrs (P_Wrkplc_Vldtn_OpJob_Id In Number,P_Wrkplc_Vldtn_OprJob_Type In Varchar2) is
337: Select WRKPLC_VLDTN_JOBFTR_ID, JOB_FEATURE_CODE, Object_Version_Number
338: From PQH_DE_WRKPLC_VLDTN_JOBFTRS
339: Where WRKPLC_VLDTN_OPR_JOB_TYPE = P_Wrkplc_Vldtn_OprJob_Type and
340: WRKPLC_VLDTN_OPR_JOB_ID = P_Wrkplc_Vldtn_OpJob_Id and
341: Business_group_id = p_Business_group_id;
342: