APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on DUAL

Line 1903: FROM DUAL;

1899: SELECT decode(p_cust_account_rec.ship_sets_include_lines_flag,p_cust_account_rec.arrivalsets_include_lines_flag,
1900: 'N',l_arrivalsets_inc_lines_f,
1901: decode(p_cust_account_rec.arrivalsets_include_lines_flag,l_ship_sets_inc_lines_f, 'Y','N'),'Y')
1902: INTO l_dummy
1903: FROM DUAL;
1904: IF l_dummy <> 'Y'
1905: THEN
1906: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
1907: FND_MESSAGE.SET_TOKEN('COLUMN1','ship_sets_include_lines_flag');

Line 1992: FROM DUAL;

1988: 'N',l_ship_sets_inc_lines_f,
1989: decode(p_cust_account_rec.ship_sets_include_lines_flag,l_arrivalsets_inc_lines_f,
1990: 'Y','N'),'Y')
1991: INTO l_dummy
1992: FROM DUAL;
1993: IF l_dummy <> 'Y'
1994: THEN
1995: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
1996: FND_MESSAGE.SET_TOKEN('COLUMN1','arrivalsets_include_lines_flag');

Line 8358: FROM DUAL

8354: AND site.org_id = p_cust_site_use_rec.org_id -- Bug 3456489
8355: AND su.org_id = p_cust_site_use_rec.org_id -- Bug 3456489
8356: AND site.CUST_ACCOUNT_ID IN (
8357: SELECT l_cust_account_id
8358: FROM DUAL
8359: UNION
8360: SELECT CUST_ACCOUNT_ID
8361: FROM HZ_CUST_ACCT_RELATE_ALL
8362: WHERE RELATED_CUST_ACCOUNT_ID = l_cust_account_id

Line 8741: FROM DUAL;

8737: 'N',l_arrivalsets_inc_lines_f,
8738: decode(p_cust_site_use_rec.arrivalsets_include_lines_flag,l_ship_sets_inc_lines_f,
8739: 'Y','N'),'Y')
8740: INTO l_dummy
8741: FROM DUAL;
8742: IF l_dummy <> 'Y'
8743: THEN
8744: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
8745: FND_MESSAGE.SET_TOKEN('COLUMN1','ship_sets_include_lines_flag');

Line 8810: FROM DUAL;

8806: 'N',l_ship_sets_inc_lines_f,
8807: decode(p_cust_site_use_rec.ship_sets_include_lines_flag,l_arrivalsets_inc_lines_f,
8808: 'Y','N'),'Y')
8809: INTO l_dummy
8810: FROM DUAL;
8811: IF l_dummy <> 'Y'
8812: THEN
8813: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
8814: FND_MESSAGE.SET_TOKEN('COLUMN1','arrivalsets_include_lines_flag');