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.

[Home] [Help]

APPS.PAY_CA_EOY_ARCHIVE dependencies on FF_USER_ENTITIES

Line 346: from ff_user_entities UE,

342: /* Get the defined_balance_id for the specified balance DB item. */
343:
344: cursor csr_defined_balance is
345: select to_number(UE.creator_id)
346: from ff_user_entities UE,
347: ff_database_items DI
348: where DI.user_name = p_db_item_name
349: and UE.user_entity_id = DI.user_entity_id
350: and Ue.creator_type = 'B'

Line 988: ff_user_entities fui

984:
985: select fdi.user_entity_id
986: into l_user_entity_id
987: from ff_database_items fdi,
988: ff_user_entities fui
989: where user_name = p_dbi_name
990: and fdi.user_entity_id = fui.user_entity_id
991: and fui.legislation_code = 'CA';
992:

Line 1911: l_province_uei ff_user_entities.user_entity_id%type;

1907: l_year_end date;
1908: l_context_no number := 60;
1909: l_count number := 0;
1910: l_jurisdiction varchar2(11);
1911: l_province_uei ff_user_entities.user_entity_id%type;
1912: l_county_uei ff_user_entities.user_entity_id%type;
1913: l_city_uei ff_user_entities.user_entity_id%type;
1914: l_county_sd_uei ff_user_entities.user_entity_id%type;
1915: l_city_sd_uei ff_user_entities.user_entity_id%type;

Line 1912: l_county_uei ff_user_entities.user_entity_id%type;

1908: l_context_no number := 60;
1909: l_count number := 0;
1910: l_jurisdiction varchar2(11);
1911: l_province_uei ff_user_entities.user_entity_id%type;
1912: l_county_uei ff_user_entities.user_entity_id%type;
1913: l_city_uei ff_user_entities.user_entity_id%type;
1914: l_county_sd_uei ff_user_entities.user_entity_id%type;
1915: l_city_sd_uei ff_user_entities.user_entity_id%type;
1916: l_province_abbrev pay_us_states.state_abbrev%type;

Line 1913: l_city_uei ff_user_entities.user_entity_id%type;

1909: l_count number := 0;
1910: l_jurisdiction varchar2(11);
1911: l_province_uei ff_user_entities.user_entity_id%type;
1912: l_county_uei ff_user_entities.user_entity_id%type;
1913: l_city_uei ff_user_entities.user_entity_id%type;
1914: l_county_sd_uei ff_user_entities.user_entity_id%type;
1915: l_city_sd_uei ff_user_entities.user_entity_id%type;
1916: l_province_abbrev pay_us_states.state_abbrev%type;
1917: l_county_name pay_us_counties.county_name%type;

Line 1914: l_county_sd_uei ff_user_entities.user_entity_id%type;

1910: l_jurisdiction varchar2(11);
1911: l_province_uei ff_user_entities.user_entity_id%type;
1912: l_county_uei ff_user_entities.user_entity_id%type;
1913: l_city_uei ff_user_entities.user_entity_id%type;
1914: l_county_sd_uei ff_user_entities.user_entity_id%type;
1915: l_city_sd_uei ff_user_entities.user_entity_id%type;
1916: l_province_abbrev pay_us_states.state_abbrev%type;
1917: l_county_name pay_us_counties.county_name%type;
1918: l_city_name pay_us_city_names.city_name%type;

Line 1915: l_city_sd_uei ff_user_entities.user_entity_id%type;

1911: l_province_uei ff_user_entities.user_entity_id%type;
1912: l_county_uei ff_user_entities.user_entity_id%type;
1913: l_city_uei ff_user_entities.user_entity_id%type;
1914: l_county_sd_uei ff_user_entities.user_entity_id%type;
1915: l_city_sd_uei ff_user_entities.user_entity_id%type;
1916: l_province_abbrev pay_us_states.state_abbrev%type;
1917: l_county_name pay_us_counties.county_name%type;
1918: l_city_name pay_us_city_names.city_name%type;
1919: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;

Line 1988: l_user_entity_id ff_user_entities.user_entity_id%TYPE;

1984: l_cpp_ee_withheld_pjgy number;
1985: l_qpp_ee_withheld_pjgy number;
1986: l_ei_ee_withheld_pjgy number;
1987: addr pay_ca_rl1_reg.primaryaddress;
1988: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
1989:
1990: other_info_amount31 number;
1991: other_info_amount53 number;
1992: other_info_amount78 number;