APPS.CST_ACCRUAL_REC_PVT dependencies on CST_WRITE_OFF_DETAILS

Line 951: into cst_write_off_details

947: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
948: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
949: sysdate -- program_update_date
950: )
951: into cst_write_off_details
952: (
953: write_off_id,
954: transaction_date,
955: amount,

Line 1247: insert into cst_write_off_details

1243: /*
1244: Insert the individual AP and/or PO transactions into
1245: the write-off details table
1246: */
1247: insert into cst_write_off_details
1248: (
1249: write_off_id,
1250: transaction_date,
1251: amount,

Line 1652: from cst_write_off_details

1648: write_off_transaction_id column in the details table
1649: */
1650: select count(*)
1651: into l_enabled
1652: from cst_write_off_details
1653: where write_off_transaction_id = p_wo_id
1654: and operating_unit_id = p_ou_id;
1655: if(l_enabled = 0) then
1656: --{

Line 1941: insert into cst_write_off_details

1937: /*
1938: Insert the details from the previous write-off but with the new write-off ID
1939: into the write-off details table
1940: */
1941: insert into cst_write_off_details
1942: (
1943: write_off_id,
1944: transaction_date,
1945: amount,

Line 1998: from cst_write_off_details cwod

1994: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1995: sysdate, --program_update_date,
1996: cwod.ae_header_id,
1997: cwod.ae_line_num
1998: from cst_write_off_details cwod
1999: where cwod.write_off_id = c_wo_rec.l_rev_id
2000: and cwod.operating_unit_id = c_wo_rec.operating_unit_id;
2001:
2002: l_stmt_num := 30;

Line 2071: from cst_write_off_details cwod,

2067: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2068: sysdate, --program_update_date,
2069: cwod.ae_header_id,
2070: cwod.ae_line_num
2071: from cst_write_off_details cwod,
2072: cst_write_offs cwo
2073: where cwo.write_off_id = c_wo_rec.l_wo_id
2074: and cwo.operating_unit_id = c_wo_rec.operating_unit_id
2075: and cwod.write_off_id = cwo.write_off_id

Line 2161: cst_write_off_details cwod

2157: sysdate, --program_update_date,
2158: cwod.ae_header_id,
2159: cwod.ae_line_num
2160: from cst_write_offs cwo,
2161: cst_write_off_details cwod
2162: where cwo.write_off_id = c_wo_rec.l_wo_id
2163: and cwo.po_distribution_id = c_wo_rec.po_distribution_id
2164: and cwo.accrual_account_id = c_wo_rec.accrual_account_id
2165: and cwo.operating_unit_id = c_wo_rec.operating_unit_id