APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_TASKS

Line 395: FROM pa_tasks t,

391: -- then select the Project level override
392: SELECT irs.ind_rate_sch_id,
393: t.cost_ind_sch_fixed_date
394: INTO l_sch_id,l_sch_date
395: FROM pa_tasks t,
396: pa_ind_rate_schedules irs
397: WHERE t.task_id = p_task_id
398: AND t.task_id = irs.task_id
399: AND irs.cost_ovr_sch_flag = 'Y';

Line 409: FROM pa_tasks t,

405: BEGIN
406: SELECT irs.ind_rate_sch_id,
407: p.cost_ind_sch_fixed_date
408: INTO l_sch_id,l_sch_date
409: FROM pa_tasks t,
410: pa_projects_all p,
411: pa_ind_rate_schedules irs
412: WHERE t.task_id = p_task_id
413: AND t.project_id = p.project_id

Line 425: FROM pa_tasks t,

421: BEGIN
422: SELECT t.cost_ind_rate_sch_id,
423: t.cost_ind_sch_fixed_date
424: INTO l_sch_id ,l_sch_date
425: FROM pa_tasks t,
426: pa_ind_rate_schedules irs
427: WHERE t.task_id = p_task_id
428: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id;
429: EXCEPTION

Line 2228: pa_tasks pt,

2224: pm.entry_level_code,
2225: DECODE(pm.entry_level_code,'P',0,pt.top_task_id) top_task_id,
2226: pbc.resource_list_member_id
2227: FROM pa_bc_packets pbc,
2228: pa_tasks pt,
2229: pa_budget_versions bv,
2230: pa_budget_entry_methods pm
2231: WHERE pbc.packet_id = p_packet_id
2232: AND pbc.budget_version_id = bv.budget_version_id

Line 6670: pa_tasks ptk,

6666: pbc.expenditure_item_date,
6667: pbc.expenditure_type
6668: FROM pa_project_types ppt,
6669: pa_projects_all pp,
6670: pa_tasks ptk,
6671: pa_bc_packets pbc
6672: WHERE
6673: ppt.project_type = pp.project_type
6674: AND pp.project_id = pbc.project_id

Line 8325: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;

8321: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8322: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8323: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8324:
8325: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
8326: l_cdl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8327: l_cdl_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
8328: l_budget_line_id pa_bc_packets.budget_line_id%TYPE;
8329: l_budget_ccid pa_bc_packets.budget_ccid%TYPE;

Line 8434: pa_tasks pt,

8430: AND gl.period_name = pbc.period_name) gl_start_date,
8431: pbc.exp_item_id,
8432: pbc.transfer_status_code
8433: FROM pa_bc_commitments_all pbc,
8434: pa_tasks pt,
8435: pa_budget_versions bv,
8436: pa_budget_entry_methods pm
8437: WHERE pbc.document_header_id = p_doc_header_id
8438: AND pbc.document_distribution_id = DECODE(substr(p_transaction_source,1,10),'PO RECEIPT',p_doc_line_number,p_doc_distribution_id)

Line 8454: FROM pa_tasks pt,

8450: CURSOR c_budget_details (p_task_id NUMBER) IS
8451: SELECT DECODE(pm.entry_level_code,'P',0,pt.top_task_id) top_task_id,
8452: bv.budget_version_id,
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

Line 9118: FROM pa_tasks pkt,

9114: AND gl.je_source_name = 'Contract Commitment'
9115: and gl.je_category_name in ('Confirmed','Provisional')
9116: and EXISTS
9117: ( SELECT 'Project Related'
9118: FROM pa_tasks pkt,
9119: pa_projects_all pp,
9120: igc_cc_acct_lines igc,
9121: igc_cc_det_pf igcpf,
9122: igc_cc_headers_all igchead,

Line 9344: FROM pa_tasks pkt,

9340: NULL po_release_Id,
9341: PA_FUNDS_CONTROL_UTILS.get_encum_type_id(igc.project_id,'STD') enc_type_id,
9342: igchead.vendor_id,
9343: pa_bc_packets_s.nextval
9344: FROM pa_tasks pkt,
9345: pa_projects_all pp,
9346: igc_cc_acct_lines igc,
9347: igc_cc_det_pf igcpf,
9348: igc_cc_headers_all igchead

Line 9428: pa_tasks pkt,

9424: igci.cc_header_id pkt_reference2,
9425: igci.cc_acct_line_id pkt_reference3,
9426: pa_bc_packets_s.nextval
9427: FROM
9428: pa_tasks pkt,
9429: pa_projects_all pp,
9430: igc_cc_interface igci,
9431: igc_cc_acct_lines igc,
9432: igc_cc_headers_all igchead,