DBA Data[Home] [Help]

APPS.PAY_IP_UTILITY dependencies on DUAL

Line 686: FROM dual;

682:
683: len_desc:=length(P_DESCRIPTION);
684: SELECT vsize(P_DESCRIPTION)
685: INTO lenb_desc
686: FROM dual;
687:
688: hr_utility.set_location('len_desription:'|| len_desc,70);
689: hr_utility.set_location('len_bytes_desription:'|| lenb_desc,80);
690:

Line 699: INTO lenb_desc FROM dual;

695: LOOP
696: len_desc:=length(L_DESCRIPTION);
697: L_DESCRIPTION:=substr(L_DESCRIPTION,1,len_desc-1);
698: SELECT vsize(L_DESCRIPTION)
699: INTO lenb_desc FROM dual;
700: END LOOP;
701: hr_utility.set_location('After loop',100);
702:
703: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

Line 1261: FROM dual

1257: (
1258: SELECT p_key_name
1259: ,p_product_name
1260: ,p_key_value
1261: FROM dual
1262: WHERE NOT EXISTS
1263: (SELECT NULL
1264: FROM hr_application_ownerships
1265: WHERE product_name = p_product_name