DBA Data[Home] [Help]

APPS.PA_CC_TRANSFER_PRICE dependencies on PA_PROJECT_ROLE_TYPES_B

Line 5182: /* Starts here bug4004792 changed the table reference to PA_PROJECT_ROLE_TYPES_B instead of the view PA_PROJECT_ROLE_TYPES for performance reason */

5178: IF l_fi_item_type_tab(1) = 'R' AND
5179: ( l_asg_fcst_job_id IS NULL OR
5180: l_asg_fcst_job_group_id IS NULL ) THEN
5181: BEGIN
5182: /* Starts here bug4004792 changed the table reference to PA_PROJECT_ROLE_TYPES_B instead of the view PA_PROJECT_ROLE_TYPES for performance reason */
5183: SELECT pa_role_job_bg_utils.get_job_id(PR.project_role_id),
5184: --PR.DEFAULT_JOB_ID,
5185: PJ.JOB_GROUP_ID
5186: INTO

Line 5189: FROM PA_PROJECT_ROLE_TYPES_B PR,

5185: PJ.JOB_GROUP_ID
5186: INTO
5187: l_asg_fcst_job_id,
5188: l_asg_fcst_job_group_id
5189: FROM PA_PROJECT_ROLE_TYPES_B PR,
5190: PER_JOBS PJ
5191: WHERE
5192: PR.PROJECT_ROLE_ID = l_asg_project_role_id AND
5193: -- PJ.JOB_ID = PR.DEFAULT_JOB_ID;