APPS.FPA_MAIN_PROCESS_PVT dependencies on FND_PROFILE

Line 85: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST') = PLC.FIN_PLAN_TYPE_ID AND

81: SELECT PLC.NAME, PLB.NAME
82: INTO L_PC_ATTRIBUTES_REC.COST_FIN_PLAN, L_PC_ATTRIBUTES_REC.BENEFIT_FIN_PLAN
83: FROM PA_FIN_PLAN_TYPES_TL PLC, PA_FIN_PLAN_TYPES_TL PLB
84: WHERE
85: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST') = PLC.FIN_PLAN_TYPE_ID AND
86: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = PLB.FIN_PLAN_TYPE_ID;
87: EXCEPTION
88: WHEN OTHERS THEN
89: NULL;

Line 86: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = PLB.FIN_PLAN_TYPE_ID;

82: INTO L_PC_ATTRIBUTES_REC.COST_FIN_PLAN, L_PC_ATTRIBUTES_REC.BENEFIT_FIN_PLAN
83: FROM PA_FIN_PLAN_TYPES_TL PLC, PA_FIN_PLAN_TYPES_TL PLB
84: WHERE
85: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST') = PLC.FIN_PLAN_TYPE_ID AND
86: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = PLB.FIN_PLAN_TYPE_ID;
87: EXCEPTION
88: WHEN OTHERS THEN
89: NULL;
90: END;

Line 243: avalue => fnd_profile.value('PJP_PORTFOLIO_CLASS_CATEGORY'));

239:
240: wf_engine.SetItemAttrText(itemtype => l_itemtype,
241: itemkey => l_itemkey,
242: aname => 'FPA_PRTF_SELECTION_CATEGORY',
243: avalue => fnd_profile.value('PJP_PORTFOLIO_CLASS_CATEGORY'));
244:
245: wf_engine.SetItemAttrText(itemtype => l_itemtype,
246: itemkey => l_itemkey,
247: aname => 'FPA_COST_FIN_PLAN_TYPE',

Line 732: organization_structure_id = FND_PROFILE.VALUE('PJP_ORGANIZATION_HIERARCHY')

728: org_structure_version_id into l_pjp_org_version_id
729: from
730: per_org_structure_versions
731: where
732: organization_structure_id = FND_PROFILE.VALUE('PJP_ORGANIZATION_HIERARCHY')
733: and (trunc(sysdate) between trunc(date_from) and trunc(nvl(date_to,
734: sysdate)));
735:
736: select