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_USER_INIT_EARN dependencies on PAY_ELEMENT_TYPES_F

Line 192: FROM pay_element_types_f

188: --
189:
190: CURSOR cur_element_type_id(p_element_name VARCHAR2) IS
191: SELECT element_type_id
192: FROM pay_element_types_f
193: WHERE upper(element_name) = upper(p_element_name)
194: AND legislation_code = 'CA';
195:
196: --

Line 203: FROM pay_input_values_f piv, pay_element_types_f pet

199:
200: CURSOR cur_input_id(p_element_name varchar2,
201: p_input_value_name varchar2) is
202: SELECT piv.input_value_id
203: FROM pay_input_values_f piv, pay_element_types_f pet
204: WHERE upper(pet.element_name) = upper(p_element_name)
205: AND pet.element_type_id = piv.element_type_id
206: AND upper(pet.legislation_code) = upper('CA')
207: AND upper(piv.name) = upper(p_input_value_name);

Line 213: FROM pay_input_values_f piv, pay_element_types_f pet

209: --
210: CURSOR cur_input_id2(p_element_type_id Number,
211: p_input_value_name varchar2) is
212: SELECT piv.input_value_id
213: FROM pay_input_values_f piv, pay_element_types_f pet
214: WHERE pet.element_type_id = p_element_type_id
215: AND pet.element_type_id = piv.element_type_id
216: /* AND upper(pet.legislation_code) = upper('CA') */
217: AND upper(piv.name) = upper(p_input_value_name);

Line 226: pay_element_types_f petf

222:
223: CURSOR cur_processing_rule_exists(p_element_type_id number) is
224: SELECT status_processing_rule_id
225: FROM pay_status_processing_rules_f pspfr,
226: pay_element_types_f petf
227: WHERE pspfr.element_type_id = petf.element_type_id
228: AND petf.element_type_id = p_element_type_id;
229:
230: --

Line 244: from pay_element_types_f pet

240: ,pet.effective_start_date
241: ,pet.effective_end_date
242: ,pet.legislation_code
243: ,pet.business_group_id
244: from pay_element_types_f pet
245: where ( pet.element_name = cp_ele_name or
246: pet.element_name = cp_ele_name || ' Special Inputs' )
247: and pet.business_group_id = cp_busi_grp_id
248: order by pet.element_name;

Line 337: l_sf_ele_info_category pay_element_types_f.element_information_category%TYPE;

333: ln_object_version_number number;
334: ld_effective_start_date date;
335: ld_effective_end_date date;
336: l_roe_allocation_by VARCHAR2(2);
337: l_sf_ele_info_category pay_element_types_f.element_information_category%TYPE;
338: l_sf_ele_category pay_element_types_f.element_information1%TYPE;
339:
340: --
341: ---------------------------- get_template_id -------------------------------

Line 338: l_sf_ele_category pay_element_types_f.element_information1%TYPE;

334: ld_effective_start_date date;
335: ld_effective_end_date date;
336: l_roe_allocation_by VARCHAR2(2);
337: l_sf_ele_info_category pay_element_types_f.element_information_category%TYPE;
338: l_sf_ele_category pay_element_types_f.element_information1%TYPE;
339:
340: --
341: ---------------------------- get_template_id -------------------------------
342: --

Line 675: from pay_element_types_f

671: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',13);
672: --
673: select element_type_id
674: into l_base_element_type_id
675: from pay_element_types_f
676: where element_name = p_ele_name
677: and business_group_id + 0 = p_bg_id;
678:
679: /* Create formula result rules ELEMENT_TYPE_ID_PASSED,HOURS_PASSED and

Line 868: update pay_element_types_f

864: --
865: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',17);
866: --
867: if (p_sep_check_option = 'N' and p_ele_calc_rule_code <> 'NTG FLT') then
868: update pay_element_types_f
869: set element_information10 = l_pri_bal_id,
870: element_information12 = l_hrs_bal_id,
871: process_mode = decode(l_sep_check_create,'Y','S','N')
872: where element_type_id = l_base_element_type_id

Line 875: update pay_element_types_f

871: process_mode = decode(l_sep_check_create,'Y','S','N')
872: where element_type_id = l_base_element_type_id
873: and business_group_id + 0 = p_bg_id;
874: elsif (p_sep_check_option = 'N' and p_ele_calc_rule_code = 'NTG FLT') then
875: update pay_element_types_f
876: set element_information10 = l_pri_bal_id,
877: element_information12 = l_hrs_bal_id,
878: process_mode = 'P'
879: where element_type_id = l_base_element_type_id

Line 883: update pay_element_types_f

879: where element_type_id = l_base_element_type_id
880: and business_group_id + 0 = p_bg_id;
881: --
882: elsif (p_sep_check_option = 'Y') then
883: update pay_element_types_f
884: set element_information10 = l_pri_bal_id,
885: element_information12 = l_hrs_bal_id,
886: process_mode = 'S'
887: where element_type_id = l_base_element_type_id

Line 913: update pay_element_types_f

909: Process Date' for all Recurring Elements */
910:
911: If p_ele_processing_type = 'R' then
912:
913: update pay_element_types_f
914: set post_termination_rule = p_termination_rule -- Bug 2646705
915: where element_type_id = l_base_element_type_id
916: and business_group_id + 0 = p_bg_id;
917:

Line 945: update pay_element_types_f

941: /* if p_ele_calc_rule_code = 'HXR' then */
942: if nvl(p_reduce_regular,'N') <> 'Y' then
943:
944: if p_ele_classification = 'Earnings' then
945: update pay_element_types_f
946: set element_information9 = 'A'
947: where element_type_id = l_base_element_type_id
948: and business_group_id + 0 = p_bg_id;
949: elsif p_ele_classification = 'Supplemental Earnings' then

Line 950: update pay_element_types_f

946: set element_information9 = 'A'
947: where element_type_id = l_base_element_type_id
948: and business_group_id + 0 = p_bg_id;
949: elsif p_ele_classification = 'Supplemental Earnings' then
950: update pay_element_types_f
951: set element_information9 = 'A'
952: where element_type_id = l_base_element_type_id
953: and business_group_id + 0 = p_bg_id;
954: end if;

Line 957: update pay_element_types_f

953: and business_group_id + 0 = p_bg_id;
954: end if;
955:
956: elsif nvl(p_reduce_regular,'N') = 'Y' then
957: update pay_element_types_f
958: set element_information9 = 'R'
959: where element_type_id = l_base_element_type_id
960: and business_group_id + 0 = p_bg_id;
961: end if;

Line 972: UPDATE pay_element_types_f

968: -- 'Earnings','Supplemental Earnings','Taxable Benefits'.
969: --
970: IF p_ele_classification in
971: ('Supplemental Earnings','Earnings','Taxable Benefits') then
972: UPDATE pay_element_types_f
973: SET element_information3 = 'DE'
974: WHERE element_type_id = l_base_element_type_id
975: AND business_group_id + 0 = p_bg_id;
976: END IF;

Line 1058: from pay_element_types_f

1054: hr_utility.trace('1 element type id is '||to_char(l_element_type_id));
1055:
1056: select element_type_id
1057: into l_element_type_id
1058: from pay_element_types_f
1059: where business_group_id = p_bg_id
1060: and element_name = p_ele_name;
1061:
1062: lv_input_value_name := 'Pay Value';

Line 1148: from pay_element_types_f

1144: --
1145: begin
1146: delete from pay_element_type_usages_f
1147: where element_type_id in ( select element_type_id
1148: from pay_element_types_f
1149: where ( element_name = p_ele_name or
1150: element_name =
1151: p_ele_name ||' Special Inputs' )
1152: and business_group_id = p_business_group_id );

Line 1212: FROM pay_element_types_f

1208: WHERE element_type_id = p_base_element_type_id;
1209:
1210: CURSOR c_seeded_elmt_id IS
1211: SELECT element_type_id
1212: FROM pay_element_types_f
1213: WHERE upper(element_name) = 'FED_GROSSUP_ADJUSTMENT'
1214: AND legislation_code = 'CA';
1215:
1216: CURSOR c_seeded_elmt_iv_id(p_seed_ele_type_id number) IS

Line 1255: UPDATE pay_element_types_f

1251: CLOSE c_iter_formula_id;
1252: -------------------------
1253: -- Set iterative formula.
1254: -------------------------
1255: UPDATE pay_element_types_f
1256: SET iterative_formula_id = l_iter_formula_id,
1257: iterative_flag = 'Y',
1258: grossup_flag = 'Y'
1259: WHERE element_type_id = p_base_element_type_id