eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_ADJUSTMENT_UTILS dependencies on PA_BUDGET_LINES

Line 396: l_sql := l_sql || ' FROM PA_BUDGET_LINES BL, PA_RESOURCE_ASSIGNMENTS RA ' ||

392: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_REV_LABOR_HOURS, ' ||
393: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :14, :15, :16, ' ||
394: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_REV_EQUIP_HOURS ' ;
395:
396: l_sql := l_sql || ' FROM PA_BUDGET_LINES BL, PA_RESOURCE_ASSIGNMENTS RA ' ||
397: ' where bl.resource_assignment_id = ra.resource_assignment_id ' ||
398: ' and bl.resource_assignment_id in ( ' || l_predicate1 || ' ) ' ||
399: ' and bl.txn_currency_code in ( ' || l_curr_code_predicate || ' ) ' ||
400: ' group by BL.RESOURCE_ASSIGNMENT_ID, BL.TXN_CURRENCY_CODE ';

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 722: from pa_resource_assignments ra, pa_budget_lines bl

718:
719: -- WBS Only - Project Level Rollup
720: CURSOR C_WBS_RES_ID_PROJ_ROLL (p_budget_version_id IN NUMBER) IS
721: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
722: from pa_resource_assignments ra, pa_budget_lines bl
723: where ra.resource_assignment_id = bl.resource_assignment_id
724: and ra.budget_version_id = p_budget_version_id;
725:
726: -- WBS Only - Project Level Self-node

Line 729: from pa_resource_assignments ra, pa_budget_lines bl

725:
726: -- WBS Only - Project Level Self-node
727: CURSOR C_WBS_RES_ID_PROJ_SELF (p_budget_version_id IN NUMBER) IS
728: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
729: from pa_resource_assignments ra, pa_budget_lines bl
730: where ra.resource_assignment_id = bl.resource_assignment_id
731: and ra.budget_version_id = p_budget_version_id
732: and ra.task_id = 0;
733:

Line 738: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

734: -- RBS only - Rollup
735: CURSOR C_RBS_RES_ID_ROLL(p_budget_version_id IN NUMBER, p_rbs_element_id IN NUMBER,
736: p_rbs_version_id IN NUMBER) IS
737: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
738: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
739: where ra.resource_assignment_id = bl.resource_assignment_id
740: and fp.fin_plan_version_id = ra.budget_version_id
741: and rbs.struct_version_id = fp.rbs_version_id
742: and rbs.sub_id = ra.rbs_element_id

Line 751: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

747: -- RBS only - Self-node
748: CURSOR C_RBS_RES_ID_SELF(p_budget_version_id IN NUMBER, p_rbs_element_id IN NUMBER,
749: p_rbs_version_id IN NUMBER) IS
750: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
751: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
752: where ra.resource_assignment_id = bl.resource_assignment_id
753: and fp.fin_plan_version_id = ra.budget_version_id
754: and rbs.struct_version_id = fp.rbs_version_id
755: and rbs.sub_id = ra.rbs_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

Line 841: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

837: -- Both - WBS Project Level Self-node RBS Rollup
838: CURSOR C_BOTH_RES_ID_PROJ_ROLL(p_budget_version_id IN NUMBER, p_rbs_element_id IN NUMBER,
839: p_rbs_version_id IN NUMBER) IS
840: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
841: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
842: where ra.resource_assignment_id = bl.resource_assignment_id
843: and fp.fin_plan_version_id = ra.budget_version_id
844: and rbs.struct_version_id = fp.rbs_version_id
845: and rbs.sub_id = ra.rbs_element_id

Line 855: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

851: -- Both - WBS Project Level Self-node RBS Self-node
852: CURSOR C_BOTH_RES_ID_PROJ_SELF(p_budget_version_id IN NUMBER, p_rbs_element_id IN NUMBER,
853: p_rbs_version_id IN NUMBER) IS
854: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
855: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
856: where ra.resource_assignment_id = bl.resource_assignment_id
857: and fp.fin_plan_version_id = ra.budget_version_id
858: and rbs.struct_version_id = fp.rbs_version_id
859: and rbs.sub_id = ra.rbs_element_id

Line 1734: ' from pa_budget_lines ' ||

1730: END IF;
1731: END LOOP;
1732:
1733: l_sql := ' select distinct resource_assignment_id, txn_currency_code ' ||
1734: ' from pa_budget_lines ' ||
1735: ' where resource_ASSIGNMENT_ID in (' || l_predicate1 || ')';
1736:
1737: OPEN l_cur FOR l_sql;
1738: l_cnt := 0;

Line 1823: ' from pa_resource_assignments pra, pa_budget_lines bl ' ||

1819: -- SQL Repository Bug 4884427; SQL ID 14901305
1820: -- Replaced l_target_budget_version_id literal with a bind variable.
1821:
1822: l_sql3 := ' select distinct pra.resource_assignment_id, bl.txn_currency_code ' ||
1823: ' from pa_resource_assignments pra, pa_budget_lines bl ' ||
1824: ' where pra.budget_version_id = :1 ' || /* to_char(l_target_budget_version_id) || */
1825: ' and pra.resource_assignment_id = bl.resource_assignment_id ' ||
1826: ' and pra.parent_assignment_id in (' || l_predicate3 || ')';
1827:

Line 1918: ' from pa_resource_assignments pra, pa_budget_lines bl ' ||

1914: -- SQL Repository Bug 4884427; SQL ID 14901323
1915: -- Replaced l_target_rev_version_id literal with a bind variable.
1916:
1917: l_sql2 := ' select distinct pra.resource_assignment_id, bl.txn_currency_code ' ||
1918: ' from pa_resource_assignments pra, pa_budget_lines bl ' ||
1919: ' where pra.budget_version_id = :1 ' || /* to_char(l_target_rev_version_id) || */
1920: ' and pra.resource_assignment_id = bl.resource_assignment_id ' ||
1921: ' and pra.parent_assignment_id in (' || l_predicate2 || ')';
1922: