eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DELTA_SYNC_MESSAGES dependencies on FND_COMMON_LOOKUPS

Line 294: p_state_code fnd_common_lookups.lookup_code%type;

290: ,p_party_site_id in NUMBER)
291: is
292:
293: p_cntry_code fnd_territories_vl.territory_code%type;
294: p_state_code fnd_common_lookups.lookup_code%type;
295: p_state_desc fnd_common_lookups.meaning%type;
296: p_enable_flag fnd_common_lookups.enabled_flag%type;
297: p_effective_date date default sysdate;
298: l_params WF_PARAMETER_LIST_T;

Line 295: p_state_desc fnd_common_lookups.meaning%type;

291: is
292:
293: p_cntry_code fnd_territories_vl.territory_code%type;
294: p_state_code fnd_common_lookups.lookup_code%type;
295: p_state_desc fnd_common_lookups.meaning%type;
296: p_enable_flag fnd_common_lookups.enabled_flag%type;
297: p_effective_date date default sysdate;
298: l_params WF_PARAMETER_LIST_T;
299: p_unique_key number;

Line 296: p_enable_flag fnd_common_lookups.enabled_flag%type;

292:
293: p_cntry_code fnd_territories_vl.territory_code%type;
294: p_state_code fnd_common_lookups.lookup_code%type;
295: p_state_desc fnd_common_lookups.meaning%type;
296: p_enable_flag fnd_common_lookups.enabled_flag%type;
297: p_effective_date date default sysdate;
298: l_params WF_PARAMETER_LIST_T;
299: p_unique_key number;
300: p_last_update_date date;

Line 324: from fnd_common_lookups fcl,fnd_territories_vl ft

320: where document_id = p_evn_key;
321:
322: cursor fet_state_sync(p_max_run_date date) is
323: select ft.territory_code,fcl.lookup_code,fcl.meaning,fcl.enabled_flag,fcl.last_update_date
324: from fnd_common_lookups fcl,fnd_territories_vl ft
325: where fcl.lookup_type = (ft.territory_code ||'_STATE')
326: and fcl.last_update_date > p_max_run_date
327: and (ft.territory_code ,fcl.lookup_code) not in (select state.country_code,state.state_code
328: from hr_state_delta_sync state

Line 347: from fnd_common_lookups fcl,fnd_territories_vl ft

343:
344: cursor fet_state_qsync(p_country_code varchar2,p_stt_code varchar2)
345: is
346: select ft.territory_code,fcl.lookup_code,fcl.meaning,fcl.enabled_flag,fcl.last_update_date
347: from fnd_common_lookups fcl,fnd_territories_vl ft
348: where fcl.lookup_type = (ft.territory_code ||'_STATE')
349: and fcl.lookup_type = (p_country_code||'_STATE')
350: and fcl.lookup_code = p_stt_code;
351: