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.PQH_COMMITMENT_POSTING dependencies on PQH_BUDGET_FUND_SRCS

Line 928: -- get the table route id for pqh_budget fund srcs

924: FETCH csr_table_route INTO g_table_route_id_bpr;
925: CLOSE csr_table_route;
926:
927: --
928: -- get the table route id for pqh_budget fund srcs
929: --
930: OPEN csr_table_route(p_table_alias => 'BFS');
931: FETCH csr_table_route INTO g_table_route_id_bfs;
932: CLOSE csr_table_route;

Line 1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;

1651: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
1652: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
1653: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
1654: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;

Line 1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;

1652: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
1653: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
1654: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;

Line 1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;

1653: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
1654: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
1661: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;

Line 1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;

1654: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
1661: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
1662: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;

Line 1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;

1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
1661: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
1662: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
1663: l_fs_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;

Line 1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;

1656: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
1661: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
1662: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
1663: l_fs_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1664: --

Line 1661: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;

1657: l_cost_allocation_keyflex_id pqh_budget_fund_srcs.cost_allocation_keyflex_id%TYPE;
1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
1661: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
1662: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
1663: l_fs_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1664: --
1665: cnt NUMBER(10) := 0;

Line 1662: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;

1658: l_project_id pqh_budget_fund_srcs.project_id%TYPE;
1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
1661: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
1662: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
1663: l_fs_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1664: --
1665: cnt NUMBER(10) := 0;
1666: --

Line 1663: l_fs_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;

1659: l_task_id pqh_budget_fund_srcs.task_id%TYPE;
1660: l_award_id pqh_budget_fund_srcs.award_id%TYPE;
1661: l_expenditure_type pqh_budget_fund_srcs.expenditure_type%TYPE;
1662: l_organization_id pqh_budget_fund_srcs.organization_id%TYPE;
1663: l_fs_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;
1664: --
1665: cnt NUMBER(10) := 0;
1666: --
1667: --

Line 1675: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,

1671: bfs.budget_fund_src_id,bfs.cost_allocation_keyflex_id,
1672: bfs.project_id,bfs.task_id,bfs.award_id,
1673: bfs.expenditure_type,bfs.organization_id,
1674: bfs.distribution_percentage
1675: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
1676: pqh_budget_sets bst
1677: WHERE bst.budget_period_id = p_budget_period_id
1678: AND bst.budget_set_id = bel.budget_set_id
1679: AND bel.budget_element_id = bfs.budget_element_id;

Line 1689: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,

1685: bfs.task_id,
1686: bfs.award_id,
1687: bfs.expenditure_type,
1688: bfs.organization_id
1689: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
1690: pqh_budget_sets bst, pqh_budget_periods bpr
1691: WHERE bpr.budget_detail_id = p_budget_detail_id
1692: AND bpr.budget_period_id = bst.budget_period_id
1693: AND bst.budget_set_id = bel.budget_set_id