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 2664: ,pa_budgetary_control_options pbct

2660: AND pp.org_id = imp.org_id
2661: AND imp.set_of_books_id = pobc.ledger_id )
2662: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'
2663: FROM pa_budget_types bdgttype
2664: ,pa_budgetary_control_options pbct
2665: WHERE pbct.project_id = pobc.pa_project_id
2666: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2667: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR
2668: pbct.EXTERNAL_BUDGET_CODE is NULL

Line 2742: ,pa_budgetary_control_options pbct

2738: AND pp.org_id = imp.org_id
2739: AND imp.set_of_books_id = apd.set_of_books_id )
2740: AND EXISTS ( SELECT 'Project Bdgt Ctrl enabled'
2741: FROM pa_budget_types bdgttype
2742: ,pa_budgetary_control_options pbct
2743: WHERE pbct.project_id = apd.project_id
2744: AND pbct.BDGT_CNTRL_FLAG = 'Y'
2745: AND (pbct.EXTERNAL_BUDGET_CODE = 'GL' OR
2746: pbct.EXTERNAL_BUDGET_CODE is NULL

Line 7188: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,

7184: p_project_id IN pa_bc_packets.project_id%TYPE,
7185: p_budget_version_id IN pa_bc_packets.budget_version_id%TYPE,
7186: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7187: p_expenditure_item_date IN DATE,
7188: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7189: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7190: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7191: x_start_date OUT NOCOPY DATE,
7192: x_end_date OUT NOCOPY DATE,

Line 7189: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,

7185: p_budget_version_id IN pa_bc_packets.budget_version_id%TYPE,
7186: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7187: p_expenditure_item_date IN DATE,
7188: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7189: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7190: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7191: x_start_date OUT NOCOPY DATE,
7192: x_end_date OUT NOCOPY DATE,
7193: x_error_code OUT NOCOPY NUMBER,

Line 7709: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,

7705: p_project_id IN pa_bc_packets.project_id%TYPE,
7706: p_budget_version_id IN pa_bc_packets.budget_version_id%TYPE,
7707: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7708: p_expenditure_item_date IN DATE,
7709: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7710: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7711: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7712: p_type IN varchar2 -- START_DATE or END_DATE OR RESULT_CODE
7713: ) return DATE is

Line 7710: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,

7706: p_budget_version_id IN pa_bc_packets.budget_version_id%TYPE,
7707: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7708: p_expenditure_item_date IN DATE,
7709: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7710: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7711: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7712: p_type IN varchar2 -- START_DATE or END_DATE OR RESULT_CODE
7713: ) return DATE is
7714:

Line 8083: pa_budgetary_control_options pbct,

8079: pm.entry_level_code
8080: FROM pa_tasks pt,
8081: pa_budget_versions bv,
8082: Pa_Budget_Types bt,
8083: pa_budgetary_control_options pbct,
8084: pa_budget_entry_methods pm
8085: WHERE pt.task_id = p_task_id
8086: AND bv.project_id = pt.project_id
8087: AND bv.BUDGET_STATUS_CODE = 'B'

Line 8752: ,pa_budgetary_control_options pbct

8748: AND imp.set_of_books_id = gl.ledger_Id
8749: AND EXISTS
8750: ( select 'Project Bdgt Ctrl enabled'
8751: from pa_budget_types bdgttype
8752: ,pa_budgetary_control_options pbct
8753: where pbct.project_id = pp.project_id
8754: and pbct.BDGT_CNTRL_FLAG = 'Y'
8755: and (pbct.EXTERNAL_BUDGET_CODE = 'GL'
8756: OR

Line 8971: ,pa_budgetary_control_options pbct

8967: AND igc.task_id = pkt.task_id
8968: AND pkt.project_id = pp.project_id
8969: AND EXISTS ( select 'Project Bdgt Ctrl enabled'
8970: from pa_budget_types bdgttype
8971: ,pa_budgetary_control_options pbct
8972: where pbct.project_id = pp.project_id
8973: and pbct.BDGT_CNTRL_FLAG = 'Y'
8974: and (pbct.EXTERNAL_BUDGET_CODE = 'GL'
8975: OR

Line 9066: ,pa_budgetary_control_options pbct

9062: AND imp.set_of_books_id = (SELECT imp1.set_of_books_id
9063: FROM pa_implementations_all imp1 where org_id = pp.org_id)
9064: AND EXISTS ( select 'Project Bdgt Ctrl enabled'
9065: from pa_budget_types bdgttype
9066: ,pa_budgetary_control_options pbct
9067: where pbct.project_id = pp.project_id
9068: and pbct.BDGT_CNTRL_FLAG = 'Y'
9069: and pbct.EXTERNAL_BUDGET_CODE = 'CC'
9070: and pbct.BUDGET_TYPE_CODE = bdgttype.budget_type_code