APPS.PA_RBS_MAPPING dependencies on PA_CROSS_BUSINESS_GRP

Line 2177: decode(head.job_id,-1,null,l_job_group_id,null,head.job_id,PA_Cross_Business_Grp.IsMappedToJob(head.job_id, l_job_group_id)), --- job, bug#4027727

2173: decode(head.resource_class_id,-1,null,head.resource_class_id), --- resource class
2174: decode(head.non_labor_resource_id,-1,null,head.non_labor_resource_id), --- non labor resource
2175: decode(head.person_type,'PJI$NULL',null,get_res_type_numeric_id(head.person_type,11)), --- person type
2176: decode(head.expenditure_organization_id,-1,null,head.expenditure_organization_id), --- organization
2177: decode(head.job_id,-1,null,l_job_group_id,null,head.job_id,PA_Cross_Business_Grp.IsMappedToJob(head.job_id, l_job_group_id)), --- job, bug#4027727
2178: decode(head.inventory_item_id,-1,null,head.inventory_item_id), --- inventory item
2179: decode(head.item_category_id,-1,null,head.item_category_id), --- item category
2180: decode(head.expenditure_type_id,-1,null,head.expenditure_type_id), --- expenditure type
2181: decode(head.expenditure_category_id,-1,null,head.expenditure_category_id), --- expenditure category

Line 2508: decode(head.job_id,-1,null,l_job_group_id,null,head.job_id,PA_Cross_Business_Grp.IsMappedToJob(head.job_id, l_job_group_id)), --- job, bug#4027727

2504: decode(head.resource_class_id,-1,null,head.resource_class_id), --- resource class
2505: decode(head.non_labor_resource_id,-1,null,head.non_labor_resource_id), --- non labor resource
2506: decode(head.person_type,'PJI$NULL',null,PA_RBS_MAPPING.get_res_type_numeric_id(head.person_type,11)), --- person type
2507: decode(head.expenditure_organization_id,-1,null,head.expenditure_organization_id), --- organization
2508: decode(head.job_id,-1,null,l_job_group_id,null,head.job_id,PA_Cross_Business_Grp.IsMappedToJob(head.job_id, l_job_group_id)), --- job, bug#4027727
2509: decode(head.inventory_item_id,-1,null,head.inventory_item_id), --- inventory item
2510: decode(head.item_category_id,-1,null,head.item_category_id), --- item category
2511: decode(head.expenditure_type_id,-1,null,head.expenditure_type_id), --- expenditure type
2512: decode(head.expenditure_category_id,-1,null,head.expenditure_category_id), --- expenditure category

Line 2884: PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)))

2880: /** Commented for bug 6662808
2881: UPDATE pa_rbs_plans_out_tmp dest
2882: SET job_id =
2883: ( decode(job_id, null, null, l_job_group_id, null, job_id,
2884: PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)))
2885: WHERE
2886: dest.job_id is not null;
2887: **/
2888:

Line 2894: SET job_id= PA_Cross_Business_Grp.IsMappedToJob(job_id,l_job_group_id)

2890:
2891: if l_job_group_id is not null then
2892:
2893: UPDATE pa_rbs_plans_out_tmp dest
2894: SET job_id= PA_Cross_Business_Grp.IsMappedToJob(job_id,l_job_group_id)
2895: WHERE dest.job_id is not null;
2896:
2897: end if;
2898: /** AEnd of addition for bug 6662808 **/

Line 2931: -- decode(job_id, null, null, l_job_group_id, null, job_id, PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)), --bug#4027727

2927: revenue_category_id, --bug#4098679
2928: resource_class_id,
2929: non_labor_resource_id,
2930: organization_id,
2931: -- decode(job_id, null, null, l_job_group_id, null, job_id, PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)), --bug#4027727
2932: job_id, --bug#4098679
2933: inventory_item_id,
2934: item_category_id,
2935: expenditure_type_id,