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 2182: pa_tasks pt,

2178: pm.entry_level_code,
2179: DECODE(pm.entry_level_code,'P',0,pt.top_task_id) top_task_id,
2180: pbc.resource_list_member_id
2181: FROM pa_bc_packets pbc,
2182: pa_tasks pt,
2183: pa_budget_versions bv,
2184: pa_budget_entry_methods pm
2185: WHERE pbc.packet_id = p_packet_id
2186: AND pbc.budget_version_id = bv.budget_version_id

Line 6327: pa_tasks ptk,

6323: pbc.expenditure_item_date,
6324: pbc.expenditure_type
6325: FROM pa_project_types ppt,
6326: pa_projects_all pp,
6327: pa_tasks ptk,
6328: pa_bc_packets pbc
6329: WHERE
6330: ppt.project_type = pp.project_type
6331: AND pp.project_id = pbc.project_id

Line 7951: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;

7947: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7948: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7949: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7950:
7951: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
7952: l_cdl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
7953: l_cdl_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
7954: l_budget_line_id pa_bc_packets.budget_line_id%TYPE;
7955: l_budget_ccid pa_bc_packets.budget_ccid%TYPE;

Line 8060: pa_tasks pt,

8056: AND gl.period_name = pbc.period_name) gl_start_date,
8057: pbc.exp_item_id,
8058: pbc.transfer_status_code
8059: FROM pa_bc_commitments_all pbc,
8060: pa_tasks pt,
8061: pa_budget_versions bv,
8062: pa_budget_entry_methods pm
8063: WHERE pbc.document_header_id = p_doc_header_id
8064: AND pbc.document_distribution_id = DECODE(substr(p_transaction_source,1,10),'PO RECEIPT',p_doc_line_number,p_doc_distribution_id)

Line 8080: FROM pa_tasks pt,

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

Line 8733: FROM pa_tasks pkt,

8729: AND gl.je_source_name = 'Contract Commitment'
8730: and gl.je_category_name in ('Confirmed','Provisional')
8731: and EXISTS
8732: ( SELECT 'Project Related'
8733: FROM pa_tasks pkt,
8734: pa_projects_all pp,
8735: igc_cc_acct_lines igc,
8736: igc_cc_det_pf igcpf,
8737: igc_cc_headers_all igchead,

Line 8956: FROM pa_tasks pkt,

8952: NULL po_release_Id,
8953: PA_FUNDS_CONTROL_UTILS.get_encum_type_id(igc.project_id,'STD') enc_type_id,
8954: igchead.vendor_id,
8955: pa_bc_packets_s.nextval
8956: FROM pa_tasks pkt,
8957: pa_projects_all pp,
8958: igc_cc_acct_lines igc,
8959: igc_cc_det_pf igcpf,
8960: igc_cc_headers_all igchead

Line 9040: pa_tasks pkt,

9036: igci.cc_header_id pkt_reference2,
9037: igci.cc_acct_line_id pkt_reference3,
9038: pa_bc_packets_s.nextval
9039: FROM
9040: pa_tasks pkt,
9041: pa_projects_all pp,
9042: igc_cc_interface igci,
9043: igc_cc_acct_lines igc,
9044: igc_cc_headers_all igchead,