DBA Data[Home] [Help]

APPS.PA_CC_TRANSFER_PRICE dependencies on PA_ROLE_JOB_BG_UTILS

Line 5279: SELECT pa_role_job_bg_utils.get_job_id(PR.project_role_id),

5275: ( l_asg_fcst_job_id IS NULL OR
5276: l_asg_fcst_job_group_id IS NULL ) THEN
5277: BEGIN
5278: /* Starts here bug4004792 changed the table reference to PA_PROJECT_ROLE_TYPES_B instead of the view PA_PROJECT_ROLE_TYPES for performance reason */
5279: SELECT pa_role_job_bg_utils.get_job_id(PR.project_role_id),
5280: --PR.DEFAULT_JOB_ID,
5281: PJ.JOB_GROUP_ID
5282: INTO
5283: l_asg_fcst_job_id,

Line 5290: PJ.JOB_ID =pa_role_job_bg_utils.get_job_id(PR.project_role_id);

5286: PER_JOBS PJ
5287: WHERE
5288: PR.PROJECT_ROLE_ID = l_asg_project_role_id AND
5289: -- PJ.JOB_ID = PR.DEFAULT_JOB_ID;
5290: PJ.JOB_ID =pa_role_job_bg_utils.get_job_id(PR.project_role_id);
5291: /* ends here */
5292: EXCEPTION
5293: WHEN NO_DATA_FOUND THEN
5294: IF p_debug_mode = 'Y' THEN