APPS.LNS_APPROVAL_ACTION_PUB dependencies on LNS_COND_ASSIGNMENTS

Line 979: update LNS_COND_ASSIGNMENTS

975: END LOOP;
976: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Toal No. of Billed and Reversed SubmitApproval Fees are: ' || l_fee_tbl.count);
977:
978: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Uncompleting all custom conditions...');
979: update LNS_COND_ASSIGNMENTS
980: set CONDITION_MET_FLAG = 'N',
981: FULFILLMENT_DATE = null,
982: FULFILLMENT_UPDATED_BY = null
983: where LOAN_ID = l_approval_action_rec.loan_id

Line 1658: from LNS_COND_ASSIGNMENTS

1654:
1655: -- checking for conditions
1656: CURSOR conditions_cur(P_LOAN_LINE_ID number) IS
1657: select count(1)
1658: from LNS_COND_ASSIGNMENTS
1659: where
1660: OWNER_OBJECT_ID = P_LOAN_LINE_ID and
1661: OWNER_TABLE = 'LNS_LOAN_LINES' and
1662: MANDATORY_FLAG = 'Y' and

Line 1929: from LNS_COND_ASSIGNMENTS

1925:
1926: -- checking for conditions
1927: CURSOR conditions_cur(P_LOAN_AMOUNT_ADJ_ID number) IS
1928: select count(1)
1929: from LNS_COND_ASSIGNMENTS
1930: where
1931: OWNER_OBJECT_ID = P_LOAN_AMOUNT_ADJ_ID and
1932: OWNER_TABLE = 'LNS_LOAN_AMOUNT_ADJS' and
1933: MANDATORY_FLAG = 'Y' and