APPS.CST_ACCRUAL_REC_PVT dependencies on CST_WRITE_OFF_DETAILS

Line 945: into cst_write_off_details

941: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
942: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
943: sysdate -- program_update_date
944: )
945: into cst_write_off_details
946: (
947: write_off_id,
948: transaction_date,
949: amount,

Line 1241: insert into cst_write_off_details

1237: /*
1238: Insert the individual AP and/or PO transactions into
1239: the write-off details table
1240: */
1241: insert into cst_write_off_details
1242: (
1243: write_off_id,
1244: transaction_date,
1245: amount,

Line 1642: from cst_write_off_details

1638: write_off_transaction_id column in the details table
1639: */
1640: select count(*)
1641: into l_enabled
1642: from cst_write_off_details
1643: where write_off_transaction_id = p_wo_id
1644: and operating_unit_id = p_ou_id;
1645: if(l_enabled = 0) then
1646: --{

Line 1931: insert into cst_write_off_details

1927: /*
1928: Insert the details from the previous write-off but with the new write-off ID
1929: into the write-off details table
1930: */
1931: insert into cst_write_off_details
1932: (
1933: write_off_id,
1934: transaction_date,
1935: amount,

Line 1988: from cst_write_off_details cwod

1984: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1985: sysdate, --program_update_date,
1986: cwod.ae_header_id,
1987: cwod.ae_line_num
1988: from cst_write_off_details cwod
1989: where cwod.write_off_id = c_wo_rec.l_rev_id
1990: and cwod.operating_unit_id = c_wo_rec.operating_unit_id;
1991:
1992: l_stmt_num := 30;

Line 2061: from cst_write_off_details cwod,

2057: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2058: sysdate, --program_update_date,
2059: cwod.ae_header_id,
2060: cwod.ae_line_num
2061: from cst_write_off_details cwod,
2062: cst_write_offs cwo
2063: where cwo.write_off_id = c_wo_rec.l_wo_id
2064: and cwo.operating_unit_id = c_wo_rec.operating_unit_id
2065: and cwod.write_off_id = cwo.write_off_id

Line 2151: cst_write_off_details cwod

2147: sysdate, --program_update_date,
2148: cwod.ae_header_id,
2149: cwod.ae_line_num
2150: from cst_write_offs cwo,
2151: cst_write_off_details cwod
2152: where cwo.write_off_id = c_wo_rec.l_wo_id
2153: and cwo.po_distribution_id = c_wo_rec.po_distribution_id
2154: and cwo.accrual_account_id = c_wo_rec.accrual_account_id
2155: and cwo.operating_unit_id = c_wo_rec.operating_unit_id