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_FUNDS_CONTROL_PKG1 dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 2711: ,pa_budgetary_control_options pbct

2707: AND pp.org_id = imp.org_id
2708: AND imp.set_of_books_id = pobc.ledger_id )
2709: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'
2710: FROM pa_budget_types bdgttype
2711: ,pa_budgetary_control_options pbct
2712: WHERE pbct.project_id = pobc.pa_project_id
2713: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2714: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR
2715: pbct.EXTERNAL_BUDGET_CODE is NULL

Line 2789: ,pa_budgetary_control_options pbct

2785: AND pp.org_id = imp.org_id
2786: AND imp.set_of_books_id = apd.set_of_books_id )
2787: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'
2788: FROM pa_budget_types bdgttype
2789: ,pa_budgetary_control_options pbct
2790: WHERE pbct.project_id = apd.project_id
2791: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2792: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR
2793: pbct.EXTERNAL_BUDGET_CODE is NULL

Line 2847: ,pa_budgetary_control_options pbct

2843: AND pp.org_id = imp.org_id
2844: AND imp.set_of_books_id = apd.set_of_books_id )
2845: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'
2846: FROM pa_budget_types bdgttype
2847: ,pa_budgetary_control_options pbct
2848: WHERE pbct.project_id = apd.project_id
2849: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2850: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR
2851: pbct.EXTERNAL_BUDGET_CODE is NULL

Line 7535: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,

7531: p_project_id IN pa_bc_packets.project_id%TYPE,
7532: p_budget_version_id IN pa_bc_packets.budget_version_id%TYPE,
7533: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7534: p_expenditure_item_date IN DATE,
7535: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7536: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7537: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7538: x_start_date OUT NOCOPY DATE,
7539: x_end_date OUT NOCOPY DATE,

Line 7536: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,

7532: p_budget_version_id IN pa_bc_packets.budget_version_id%TYPE,
7533: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7534: p_expenditure_item_date IN DATE,
7535: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7536: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7537: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7538: x_start_date OUT NOCOPY DATE,
7539: x_end_date OUT NOCOPY DATE,
7540: x_error_code OUT NOCOPY NUMBER,

Line 8078: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,

8074: p_project_id IN pa_bc_packets.project_id%TYPE,
8075: p_budget_version_id IN pa_bc_packets.budget_version_id%TYPE,
8076: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
8077: p_expenditure_item_date IN DATE,
8078: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
8079: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
8080: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
8081: p_type IN varchar2 -- START_DATE or END_DATE OR RESULT_CODE
8082: ) return DATE is

Line 8079: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,

8075: p_budget_version_id IN pa_bc_packets.budget_version_id%TYPE,
8076: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
8077: p_expenditure_item_date IN DATE,
8078: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
8079: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
8080: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
8081: p_type IN varchar2 -- START_DATE or END_DATE OR RESULT_CODE
8082: ) return DATE is
8083:

Line 8457: pa_budgetary_control_options pbct,

8453: pm.entry_level_code
8454: FROM pa_tasks pt,
8455: pa_budget_versions bv,
8456: Pa_Budget_Types bt,
8457: pa_budgetary_control_options pbct,
8458: pa_budget_entry_methods pm
8459: WHERE pt.task_id = p_task_id
8460: AND bv.project_id = pt.project_id
8461: AND bv.BUDGET_STATUS_CODE = 'B'

Line 9137: ,pa_budgetary_control_options pbct

9133: AND imp.set_of_books_id = gl.ledger_Id
9134: AND EXISTS
9135: ( select 'Project Bdgt Ctrl enabled'
9136: from pa_budget_types bdgttype
9137: ,pa_budgetary_control_options pbct
9138: where pbct.project_id = pp.project_id
9139: and pbct.BDGT_CNTRL_FLAG = 'Y'
9140: and (pbct.EXTERNAL_BUDGET_CODE = 'GL'
9141: OR

Line 9359: ,pa_budgetary_control_options pbct

9355: AND igc.task_id = pkt.task_id
9356: AND pkt.project_id = pp.project_id
9357: AND EXISTS ( select 'Project Bdgt Ctrl enabled'
9358: from pa_budget_types bdgttype
9359: ,pa_budgetary_control_options pbct
9360: where pbct.project_id = pp.project_id
9361: and pbct.BDGT_CNTRL_FLAG = 'Y'
9362: and (pbct.EXTERNAL_BUDGET_CODE = 'GL'
9363: OR

Line 9454: ,pa_budgetary_control_options pbct

9450: AND imp.set_of_books_id = (SELECT imp1.set_of_books_id
9451: FROM pa_implementations_all imp1 where org_id = pp.org_id)
9452: AND EXISTS ( select 'Project Bdgt Ctrl enabled'
9453: from pa_budget_types bdgttype
9454: ,pa_budgetary_control_options pbct
9455: where pbct.project_id = pp.project_id
9456: and pbct.BDGT_CNTRL_FLAG = 'Y'
9457: and pbct.EXTERNAL_BUDGET_CODE = 'CC'
9458: and pbct.BUDGET_TYPE_CODE = bdgttype.budget_type_code