DBA Data[Home] [Help]

APPS.XTR_LIMITS_P dependencies on XTR_GROUP_LIMITS

Line 1234: FROM xtr_group_limits

1230: --
1231: cursor c_get_util(pc1_company_code VARCHAR2,pc1_limit_type VARCHAR2,
1232: pc1_limit_party VARCHAR2) is
1233: SELECT nvl(limit_amount,0), nvl(utilised_amount,0)
1234: FROM xtr_group_limits
1235: WHERE company_code = pc1_company_code
1236: AND cparty_code = pc1_limit_party
1237: AND ((limit_type = pc1_limit_type and limit_type <>'XI')
1238: or (limit_type='XI' and pc1_limit_type in('X','I')))

Line 1834: update xtr_GROUP_LIMITS_V

1830: update xtr_MASTER_CURRENCIES
1831: set UTILISED_AMOUNT = 0;
1832: update xtr_COUNTRY_COMPANY_LIMITS_V
1833: set UTILISED_AMOUNT = 0;
1834: update xtr_GROUP_LIMITS_V
1835: set UTILISED_AMOUNT = 0;
1836: --
1837: -- Insert Trigger on MIRROR_DDA_LIMIT_ROW_TEMP will initialize all
1838: -- limits in above tables