APPS.HR_FULL_SYNC_MESSAGES dependencies on FND_COMMON_LOOKUPS

Line 154: p_state_code fnd_common_lookups.lookup_code%type;

150: ,retcode OUT NOCOPY VARCHAR2)
151: is
152:
153: p_cntry_code fnd_territories_vl.territory_code%type;
154: p_state_code fnd_common_lookups.lookup_code%type;
155: p_state_desc fnd_common_lookups.meaning%type;
156: p_enabled_flag fnd_common_lookups.enabled_flag%type;
157: p_effective_date date default sysdate;
158:

Line 155: p_state_desc fnd_common_lookups.meaning%type;

151: is
152:
153: p_cntry_code fnd_territories_vl.territory_code%type;
154: p_state_code fnd_common_lookups.lookup_code%type;
155: p_state_desc fnd_common_lookups.meaning%type;
156: p_enabled_flag fnd_common_lookups.enabled_flag%type;
157: p_effective_date date default sysdate;
158:
159:

Line 156: p_enabled_flag fnd_common_lookups.enabled_flag%type;

152:
153: p_cntry_code fnd_territories_vl.territory_code%type;
154: p_state_code fnd_common_lookups.lookup_code%type;
155: p_state_desc fnd_common_lookups.meaning%type;
156: p_enabled_flag fnd_common_lookups.enabled_flag%type;
157: p_effective_date date default sysdate;
158:
159:
160:

Line 163: from fnd_common_lookups fcl,fnd_territories_vl ft

159:
160:
161: cursor fet_state_sync is
162: select ft.territory_code,fcl.lookup_code,fcl.meaning,fcl.enabled_flag
163: from fnd_common_lookups fcl,fnd_territories_vl ft
164: where fcl.lookup_type = (ft.territory_code ||'_STATE')
165: order by ft.territory_code;
166:
167: cursor fet_psft_sync is