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.PAY_CA_EOY_ARCHIVE dependencies on FF_USER_ENTITIES

Line 413: from ff_user_entities UE,

409: /* Get the defined_balance_id for the specified balance DB item. */
410:
411: cursor csr_defined_balance is
412: select to_number(UE.creator_id)
413: from ff_user_entities UE,
414: ff_database_items DI
415: where DI.user_name = p_db_item_name
416: and UE.user_entity_id = DI.user_entity_id
417: and Ue.creator_type = 'B'

Line 1155: ff_user_entities fui

1151:
1152: select fdi.user_entity_id
1153: into l_user_entity_id
1154: from ff_database_items fdi,
1155: ff_user_entities fui
1156: where user_name = p_dbi_name
1157: and fdi.user_entity_id = fui.user_entity_id
1158: and fui.legislation_code = 'CA';
1159:

Line 2129: l_province_uei ff_user_entities.user_entity_id%type;

2125: l_year_end date;
2126: l_context_no number := 60;
2127: l_count number := 0;
2128: l_jurisdiction varchar2(11);
2129: l_province_uei ff_user_entities.user_entity_id%type;
2130: l_county_uei ff_user_entities.user_entity_id%type;
2131: l_city_uei ff_user_entities.user_entity_id%type;
2132: l_county_sd_uei ff_user_entities.user_entity_id%type;
2133: l_city_sd_uei ff_user_entities.user_entity_id%type;

Line 2130: l_county_uei ff_user_entities.user_entity_id%type;

2126: l_context_no number := 60;
2127: l_count number := 0;
2128: l_jurisdiction varchar2(11);
2129: l_province_uei ff_user_entities.user_entity_id%type;
2130: l_county_uei ff_user_entities.user_entity_id%type;
2131: l_city_uei ff_user_entities.user_entity_id%type;
2132: l_county_sd_uei ff_user_entities.user_entity_id%type;
2133: l_city_sd_uei ff_user_entities.user_entity_id%type;
2134: l_province_abbrev pay_us_states.state_abbrev%type;

Line 2131: l_city_uei ff_user_entities.user_entity_id%type;

2127: l_count number := 0;
2128: l_jurisdiction varchar2(11);
2129: l_province_uei ff_user_entities.user_entity_id%type;
2130: l_county_uei ff_user_entities.user_entity_id%type;
2131: l_city_uei ff_user_entities.user_entity_id%type;
2132: l_county_sd_uei ff_user_entities.user_entity_id%type;
2133: l_city_sd_uei ff_user_entities.user_entity_id%type;
2134: l_province_abbrev pay_us_states.state_abbrev%type;
2135: l_county_name pay_us_counties.county_name%type;

Line 2132: l_county_sd_uei ff_user_entities.user_entity_id%type;

2128: l_jurisdiction varchar2(11);
2129: l_province_uei ff_user_entities.user_entity_id%type;
2130: l_county_uei ff_user_entities.user_entity_id%type;
2131: l_city_uei ff_user_entities.user_entity_id%type;
2132: l_county_sd_uei ff_user_entities.user_entity_id%type;
2133: l_city_sd_uei ff_user_entities.user_entity_id%type;
2134: l_province_abbrev pay_us_states.state_abbrev%type;
2135: l_county_name pay_us_counties.county_name%type;
2136: l_city_name pay_us_city_names.city_name%type;

Line 2133: l_city_sd_uei ff_user_entities.user_entity_id%type;

2129: l_province_uei ff_user_entities.user_entity_id%type;
2130: l_county_uei ff_user_entities.user_entity_id%type;
2131: l_city_uei ff_user_entities.user_entity_id%type;
2132: l_county_sd_uei ff_user_entities.user_entity_id%type;
2133: l_city_sd_uei ff_user_entities.user_entity_id%type;
2134: l_province_abbrev pay_us_states.state_abbrev%type;
2135: l_county_name pay_us_counties.county_name%type;
2136: l_city_name pay_us_city_names.city_name%type;
2137: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;

Line 2206: l_user_entity_id ff_user_entities.user_entity_id%TYPE;

2202: l_cpp_ee_withheld_pjgy number;
2203: l_qpp_ee_withheld_pjgy number;
2204: l_ei_ee_withheld_pjgy number;
2205: addr pay_ca_rl1_reg.primaryaddress;
2206: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
2207:
2208: other_info_amount31 number;
2209: other_info_amount53 number;
2210: other_info_amount78 number;