APPS.PA_CROSS_BUSINESS_GRP dependencies on PA_JOB_RELATIONSHIPS_VIEW

Line 25: * pa_job_relationships_view to accomplish this if the FromJobId ToJobGroupId has not

21: IS
22:
23: /* This function should be used by views and conditional type of needs to return the
24: * ToJobId based on the FromJobId and ToJobGroupId passed in. Note that we use view
25: * pa_job_relationships_view to accomplish this if the FromJobId ToJobGroupId has not
26: * been stored in the plsql table already. If view has to be checked to get the
27: * ToJobId then the value retrieved will be placed in the plsql table for performance
28: * improvements.
29: */

Line 90: from pa_job_relationships_view

86: * job relationships view.
87: */
88: select to_job_id
89: into l_To_Job_Id
90: from pa_job_relationships_view
91: where from_job_id = P_From_Job_Id
92: and to_job_group_id = P_To_Job_Group_Id ;
93:
94: G_FromJobToGrp(TABLE_SIZE) := l_FromJobToGrp;

Line 198: from pa_job_relationships_view

194: */
195: cursor getJob( from_job_id IN NUMBER,
196: to_grp_id IN NUMBER) IS
197: select to_job_id
198: from pa_job_relationships_view
199: where from_job_id = from_job_id
200: and to_job_group_id = to_grp_id ;
201:
202: l_MinRecs NUMBER ;