APPS.PA_FP_ADJUSTMENT_UTILS dependencies on PJI_XBS_DENORM

Line 698: from pji_xbs_denorm xbs, pa_resource_assignments ra, pa_budget_lines bl

694: -- WBS only - Rollup
695: CURSOR C_WBS_RES_ID_ROLL(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
696: p_wbs_structure_version_id IN NUMBER) IS
697: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
698: from pji_xbs_denorm xbs, pa_resource_assignments ra, pa_budget_lines bl
699: where ra.resource_assignment_id = bl.resource_assignment_id
700: and xbs.sub_emt_id = ra.task_id
701: and ra.budget_version_id = p_budget_version_id
702: and xbs.sup_emt_id = p_wbs_element_id

Line 710: from pji_xbs_denorm xbs, pa_resource_assignments ra, pa_budget_lines bl

706: -- WBS only - Self-node
707: CURSOR C_WBS_RES_ID_SELF(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
708: p_wbs_structure_version_id IN NUMBER) IS
709: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
710: from pji_xbs_denorm xbs, pa_resource_assignments ra, pa_budget_lines bl
711: where ra.resource_assignment_id = bl.resource_assignment_id
712: and xbs.sub_emt_id = ra.task_id
713: and ra.budget_version_id = p_budget_version_id
714: and xbs.sup_emt_id = p_wbs_element_id

Line 766: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

762: CURSOR C_BOTH_RES_ID_ROLL_ROLL(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
763: p_rbs_element_id IN NUMBER, p_rbs_version_id IN NUMBER,
764: p_wbs_structure_version_id IN NUMBER) IS
765: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
766: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
767: where ra.resource_assignment_id = bl.resource_assignment_id
768: and rbs.struct_version_id = fp.rbs_version_id
769: and rbs.sub_id = ra.rbs_element_id
770: and xbs.sub_emt_id = ra.task_id

Line 784: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

780: CURSOR C_BOTH_RES_ID_ROLL_SELF(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
781: p_rbs_element_id IN NUMBER, p_rbs_version_id IN NUMBER,
782: p_wbs_structure_version_id IN NUMBER) IS
783: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
784: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
785: where ra.resource_assignment_id = bl.resource_assignment_id
786: and rbs.struct_version_id = fp.rbs_version_id
787: and rbs.sub_id = ra.rbs_element_id
788: and xbs.sub_emt_id = ra.task_id

Line 803: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

799: CURSOR C_BOTH_RES_ID_SELF_ROLL(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
800: p_rbs_element_id IN NUMBER, p_rbs_version_id IN NUMBER,
801: p_wbs_structure_version_id IN NUMBER) IS
802: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
803: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
804: where ra.resource_assignment_id = bl.resource_assignment_id
805: and rbs.struct_version_id = fp.rbs_version_id
806: and rbs.sub_id = ra.rbs_element_id
807: and xbs.sub_emt_id = ra.task_id

Line 822: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

818: CURSOR C_BOTH_RES_ID_SELF_SELF(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
819: p_rbs_element_id IN NUMBER, p_rbs_version_id IN NUMBER,
820: p_wbs_structure_version_id IN NUMBER) IS
821: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
822: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
823: where ra.resource_assignment_id = bl.resource_assignment_id
824: and rbs.struct_version_id = fp.rbs_version_id
825: and rbs.sub_id = ra.rbs_element_id
826: and xbs.sub_emt_id = ra.task_id