69: INTO P_SEQUENCE_ID
70: FROM
71: DUAL;
72: IF P_ALL_ORGS = 1 THEN
73: L_RESP_ID := FND_PROFILE.VALUE('RESP_ID');
74: L_RESP_APPL_ID := FND_PROFILE.VALUE('RESP_APPL_ID');
75: L_INDEX := 0;
76: FOR c_org IN (SELECT
77: ORGANIZATION_ID
70: FROM
71: DUAL;
72: IF P_ALL_ORGS = 1 THEN
73: L_RESP_ID := FND_PROFILE.VALUE('RESP_ID');
74: L_RESP_APPL_ID := FND_PROFILE.VALUE('RESP_APPL_ID');
75: L_INDEX := 0;
76: FOR c_org IN (SELECT
77: ORGANIZATION_ID
78: FROM