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 187: FROM pay_element_types_f

183: --
184:
185: CURSOR cur_element_type_id(p_element_name VARCHAR2) IS
186: SELECT element_type_id
187: FROM pay_element_types_f
188: WHERE upper(element_name) = upper(p_element_name)
189: AND legislation_code = 'CA';
190:
191: --

Line 198: FROM pay_input_values_f piv, pay_element_types_f pet

194:
195: CURSOR cur_input_id(p_element_name varchar2,
196: p_input_value_name varchar2) is
197: SELECT piv.input_value_id
198: FROM pay_input_values_f piv, pay_element_types_f pet
199: WHERE upper(pet.element_name) = upper(p_element_name)
200: AND pet.element_type_id = piv.element_type_id
201: AND upper(pet.legislation_code) = upper('CA')
202: AND upper(piv.name) = upper(p_input_value_name);

Line 208: FROM pay_input_values_f piv, pay_element_types_f pet

204: --
205: CURSOR cur_input_id2(p_element_type_id Number,
206: p_input_value_name varchar2) is
207: SELECT piv.input_value_id
208: FROM pay_input_values_f piv, pay_element_types_f pet
209: WHERE pet.element_type_id = p_element_type_id
210: AND pet.element_type_id = piv.element_type_id
211: /* AND upper(pet.legislation_code) = upper('CA') */
212: AND upper(piv.name) = upper(p_input_value_name);

Line 221: pay_element_types_f petf

217:
218: CURSOR cur_processing_rule_exists(p_element_type_id number) is
219: SELECT status_processing_rule_id
220: FROM pay_status_processing_rules_f pspfr,
221: pay_element_types_f petf
222: WHERE pspfr.element_type_id = petf.element_type_id
223: AND petf.element_type_id = p_element_type_id;
224:
225: --

Line 239: from pay_element_types_f pet

235: ,pet.effective_start_date
236: ,pet.effective_end_date
237: ,pet.legislation_code
238: ,pet.business_group_id
239: from pay_element_types_f pet
240: where ( pet.element_name = cp_ele_name or
241: pet.element_name = cp_ele_name || ' Special Inputs' )
242: and pet.business_group_id = cp_busi_grp_id
243: order by pet.element_name;

Line 332: l_sf_ele_info_category pay_element_types_f.element_information_category%TYPE;

328: ln_object_version_number number;
329: ld_effective_start_date date;
330: ld_effective_end_date date;
331: l_roe_allocation_by VARCHAR2(2);
332: l_sf_ele_info_category pay_element_types_f.element_information_category%TYPE;
333: l_sf_ele_category pay_element_types_f.element_information1%TYPE;
334:
335: --
336: ---------------------------- get_template_id -------------------------------

Line 333: l_sf_ele_category pay_element_types_f.element_information1%TYPE;

329: ld_effective_start_date date;
330: ld_effective_end_date date;
331: l_roe_allocation_by VARCHAR2(2);
332: l_sf_ele_info_category pay_element_types_f.element_information_category%TYPE;
333: l_sf_ele_category pay_element_types_f.element_information1%TYPE;
334:
335: --
336: ---------------------------- get_template_id -------------------------------
337: --

Line 667: from pay_element_types_f

663: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',13);
664: --
665: select element_type_id
666: into l_base_element_type_id
667: from pay_element_types_f
668: where element_name = p_ele_name
669: and business_group_id + 0 = p_bg_id;
670:
671: /* Create formula result rules ELEMENT_TYPE_ID_PASSED,HOURS_PASSED and

Line 860: update pay_element_types_f

856: --
857: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_earning',17);
858: --
859: if (p_sep_check_option = 'N' and p_ele_calc_rule_code <> 'NTG FLT') then
860: update pay_element_types_f
861: set element_information10 = l_pri_bal_id,
862: element_information12 = l_hrs_bal_id,
863: process_mode = decode(l_sep_check_create,'Y','S','N')
864: where element_type_id = l_base_element_type_id

Line 867: update pay_element_types_f

863: process_mode = decode(l_sep_check_create,'Y','S','N')
864: where element_type_id = l_base_element_type_id
865: and business_group_id + 0 = p_bg_id;
866: elsif (p_sep_check_option = 'N' and p_ele_calc_rule_code = 'NTG FLT') then
867: update pay_element_types_f
868: set element_information10 = l_pri_bal_id,
869: element_information12 = l_hrs_bal_id,
870: process_mode = 'P'
871: where element_type_id = l_base_element_type_id

Line 875: update pay_element_types_f

871: where element_type_id = l_base_element_type_id
872: and business_group_id + 0 = p_bg_id;
873: --
874: elsif (p_sep_check_option = 'Y') 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 = 'S'
879: where element_type_id = l_base_element_type_id

Line 905: update pay_element_types_f

901: Process Date' for all Recurring Elements */
902:
903: If p_ele_processing_type = 'R' then
904:
905: update pay_element_types_f
906: set post_termination_rule = p_termination_rule -- Bug 2646705
907: where element_type_id = l_base_element_type_id
908: and business_group_id + 0 = p_bg_id;
909:

Line 937: update pay_element_types_f

933: /* if p_ele_calc_rule_code = 'HXR' then */
934: if nvl(p_reduce_regular,'N') <> 'Y' then
935:
936: if p_ele_classification = 'Earnings' then
937: update pay_element_types_f
938: set element_information9 = 'A'
939: where element_type_id = l_base_element_type_id
940: and business_group_id + 0 = p_bg_id;
941: elsif p_ele_classification = 'Supplemental Earnings' then

Line 942: update pay_element_types_f

938: set element_information9 = 'A'
939: where element_type_id = l_base_element_type_id
940: and business_group_id + 0 = p_bg_id;
941: elsif p_ele_classification = 'Supplemental Earnings' then
942: update pay_element_types_f
943: set element_information9 = 'A'
944: where element_type_id = l_base_element_type_id
945: and business_group_id + 0 = p_bg_id;
946: end if;

Line 949: update pay_element_types_f

945: and business_group_id + 0 = p_bg_id;
946: end if;
947:
948: elsif nvl(p_reduce_regular,'N') = 'Y' then
949: update pay_element_types_f
950: set element_information9 = 'R'
951: where element_type_id = l_base_element_type_id
952: and business_group_id + 0 = p_bg_id;
953: end if;

Line 964: UPDATE pay_element_types_f

960: -- 'Earnings','Supplemental Earnings','Taxable Benefits'.
961: --
962: IF p_ele_classification in
963: ('Supplemental Earnings','Earnings','Taxable Benefits') then
964: UPDATE pay_element_types_f
965: SET element_information3 = 'DE'
966: WHERE element_type_id = l_base_element_type_id
967: AND business_group_id + 0 = p_bg_id;
968: END IF;

Line 1050: from pay_element_types_f

1046: hr_utility.trace('1 element type id is '||to_char(l_element_type_id));
1047:
1048: select element_type_id
1049: into l_element_type_id
1050: from pay_element_types_f
1051: where business_group_id = p_bg_id
1052: and element_name = p_ele_name;
1053:
1054: lv_input_value_name := 'Pay Value';

Line 1140: from pay_element_types_f

1136: --
1137: begin
1138: delete from pay_element_type_usages_f
1139: where element_type_id in ( select element_type_id
1140: from pay_element_types_f
1141: where ( element_name = p_ele_name or
1142: element_name =
1143: p_ele_name ||' Special Inputs' )
1144: and business_group_id = p_business_group_id );

Line 1204: FROM pay_element_types_f

1200: WHERE element_type_id = p_base_element_type_id;
1201:
1202: CURSOR c_seeded_elmt_id IS
1203: SELECT element_type_id
1204: FROM pay_element_types_f
1205: WHERE upper(element_name) = 'FED_GROSSUP_ADJUSTMENT'
1206: AND legislation_code = 'CA';
1207:
1208: CURSOR c_seeded_elmt_iv_id(p_seed_ele_type_id number) IS

Line 1247: UPDATE pay_element_types_f

1243: CLOSE c_iter_formula_id;
1244: -------------------------
1245: -- Set iterative formula.
1246: -------------------------
1247: UPDATE pay_element_types_f
1248: SET iterative_formula_id = l_iter_formula_id,
1249: iterative_flag = 'Y',
1250: grossup_flag = 'Y'
1251: WHERE element_type_id = p_base_element_type_id