82: l_ff_owner varchar2(30);
83: l_fnd_owner varchar2(30);
84: l_apps_owner varchar2(30);
85:
86: l_ret1 boolean := FND_INSTALLATION.GET_APP_INFO ('PAY', l_status,
87: l_industry, l_pay_owner);
88: l_ret2 boolean := FND_INSTALLATION.GET_APP_INFO ('BEN', l_status,
89: l_industry, l_ben_owner);
90: l_ret3 boolean := FND_INSTALLATION.GET_APP_INFO ('FF', l_status,
84: l_apps_owner varchar2(30);
85:
86: l_ret1 boolean := FND_INSTALLATION.GET_APP_INFO ('PAY', l_status,
87: l_industry, l_pay_owner);
88: l_ret2 boolean := FND_INSTALLATION.GET_APP_INFO ('BEN', l_status,
89: l_industry, l_ben_owner);
90: l_ret3 boolean := FND_INSTALLATION.GET_APP_INFO ('FF', l_status,
91: l_industry, l_ff_owner);
92: l_ret5 boolean := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
86: l_ret1 boolean := FND_INSTALLATION.GET_APP_INFO ('PAY', l_status,
87: l_industry, l_pay_owner);
88: l_ret2 boolean := FND_INSTALLATION.GET_APP_INFO ('BEN', l_status,
89: l_industry, l_ben_owner);
90: l_ret3 boolean := FND_INSTALLATION.GET_APP_INFO ('FF', l_status,
91: l_industry, l_ff_owner);
92: l_ret5 boolean := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
93: l_industry, l_per_owner);
94: l_ret6 boolean := FND_INSTALLATION.GET_APP_INFO ('APPS', l_status,
88: l_ret2 boolean := FND_INSTALLATION.GET_APP_INFO ('BEN', l_status,
89: l_industry, l_ben_owner);
90: l_ret3 boolean := FND_INSTALLATION.GET_APP_INFO ('FF', l_status,
91: l_industry, l_ff_owner);
92: l_ret5 boolean := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
93: l_industry, l_per_owner);
94: l_ret6 boolean := FND_INSTALLATION.GET_APP_INFO ('APPS', l_status,
95: l_industry, l_apps_owner);
96:
90: l_ret3 boolean := FND_INSTALLATION.GET_APP_INFO ('FF', l_status,
91: l_industry, l_ff_owner);
92: l_ret5 boolean := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
93: l_industry, l_per_owner);
94: l_ret6 boolean := FND_INSTALLATION.GET_APP_INFO ('APPS', l_status,
95: l_industry, l_apps_owner);
96:
97: -- select tables for generating where
98: -- 1. generator not yet run (last_generated_date is null) OR