APPS.CSF_DEBRIEF_PVT dependencies on CS_TXN_BILLING_TYPES

Line 979: l_billing_type cs_txn_billing_types.billing_type%type;

975: closed_assignment_count number;
976: l_debrief_line_id number;
977: x number;
978: l_business_process_id number;
979: l_billing_type cs_txn_billing_types.billing_type%type;
980: l_task_object_version_number number;
981: l_task_status_id number;
982: l_task_status_name varchar2(200);
983: xx_labor_start_date date;

Line 1032: cs_txn_billing_types ctbt

1028: select ctbt.billing_type,
1029: cttv.line_order_category_code,
1030: cttv.transaction_type_id
1031: from cs_transaction_types_vl cttv,
1032: cs_txn_billing_types ctbt
1033: where ctbt.txn_billing_type_id = p_txn_billing_type_id
1034: and ctbt.transaction_type_id = cttv.transaction_type_id;
1035:
1036: cursor c_transaction_type_id (p_transaction_type_id number,

Line 1041: cs_txn_billing_types ctbt,

1037: p_inventory_item_id number) is
1038: select ctbt.billing_type,
1039: cttv.line_order_category_code
1040: from cs_transaction_types_vl cttv,
1041: cs_txn_billing_types ctbt,
1042: mtl_system_items_b_kfv msibk
1043: where cttv.transaction_type_id = p_transaction_type_id
1044: and cttv.transaction_type_id = ctbt.transaction_type_id
1045: and ctbt.billing_type = msibk.material_billable_flag

Line 1921: l_billing_type cs_txn_billing_types.billing_type%type;

1917: closed_assignment_count number;
1918: l_charge_upload_status varchar2(30);
1919: L_DEBRIEF_LINE_ID number;
1920: l_business_process_id number;
1921: l_billing_type cs_txn_billing_types.billing_type%type;
1922: l_task_object_version_number number;
1923: l_task_status_id number;
1924: l_task_status_name varchar2(200);
1925: l_data varchar2(500);

Line 3371: cs_txn_billing_types ctbt

3367: select 'Y'
3368: from csf_debrief_headers cdh,
3369: csf_debrief_lines cdl,
3370: cs_transaction_types ctt,
3371: cs_txn_billing_types ctbt
3372: where cdh.task_assignment_id = p_task_assignment_id
3373: and cdl.debrief_header_id = cdh.debrief_header_id
3374: and ctt.transaction_type_id = cdl.transaction_type_id
3375: and ctbt.transaction_type_id = ctt.transaction_type_id

Line 3384: cs_txn_billing_types ctbt

3380: select 'Y'
3381: from csf_debrief_headers cdh,
3382: csf_debrief_lines cdl,
3383: cs_transaction_types ctt,
3384: cs_txn_billing_types ctbt
3385: where cdh.task_assignment_id = p_task_assignment_id
3386: and cdl.debrief_header_id = cdh.debrief_header_id
3387: and ctt.transaction_type_id = cdl.transaction_type_id
3388: and ctbt.transaction_type_id = ctt.transaction_type_id