eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_APPROVAL_ACTION_PUB dependencies on LNS_LOAN_AMOUNT_ADJS

Line 1921: from LNS_LOAN_AMOUNT_ADJS adj,

1917: loan.LOAN_CURRENCY,
1918: adj.DESCRIPTION,
1919: to_char(adj.ADJUSTMENT_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
1920: adj.EFFECTIVE_DATE
1921: from LNS_LOAN_AMOUNT_ADJS adj,
1922: lns_loan_headers_all loan
1923: where adj.LOAN_AMOUNT_ADJ_ID = P_LOAN_AMOUNT_ADJ_ID and
1924: adj.loan_id = loan.loan_id;
1925:

Line 1932: OWNER_TABLE = 'LNS_LOAN_AMOUNT_ADJS' and

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
1934: (CONDITION_MET_FLAG is null or CONDITION_MET_FLAG = 'N') and
1935: (end_date_active is null or trunc(end_date_active) > trunc(sysdate));
1936: