APPS.CSF_DEBRIEF_PVT dependencies on CS_TXN_BILLING_TYPES

Line 977: l_billing_type cs_txn_billing_types.billing_type%type;

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

Line 1030: cs_txn_billing_types ctbt

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

Line 1039: cs_txn_billing_types ctbt,

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

Line 1868: l_billing_type cs_txn_billing_types.billing_type%type;

1864: closed_assignment_count number;
1865: l_charge_upload_status varchar2(30);
1866: L_DEBRIEF_LINE_ID number;
1867: l_business_process_id number;
1868: l_billing_type cs_txn_billing_types.billing_type%type;
1869: l_task_object_version_number number;
1870: l_task_status_id number;
1871: l_task_status_name varchar2(200);
1872: l_data varchar2(500);