DBA Data[Home] [Help]

APPS.PA_CC_TRANSFER_PRICE dependencies on PA_PROJECT_ROLE_TYPES_B

Line 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 */

5274: IF l_fi_item_type_tab(1) = 'R' AND
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

Line 5285: FROM PA_PROJECT_ROLE_TYPES_B PR,

5281: PJ.JOB_GROUP_ID
5282: INTO
5283: l_asg_fcst_job_id,
5284: l_asg_fcst_job_group_id
5285: FROM PA_PROJECT_ROLE_TYPES_B PR,
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;