APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_ELEMENT_TYPES_F

Line 99: from pay_element_types_f pet

95: ,pet.effective_end_date
96: ,pet.legislation_code
97: ,pet.business_group_id
98: ,NULL usage_type
99: from pay_element_types_f pet
100: ,pay_run_types_f prt
101: where pet.element_name = p_element_name
102: and pet.business_group_id = p_bg_id
103: and prt.legislation_code = 'CA'

Line 521: from pay_element_types_f

517: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',13);
518: --
519: select element_type_id
520: into l_base_element_type_id
521: from pay_element_types_f
522: where element_name = p_ele_name
523: and business_group_id + 0 = p_bg_id;
524: --
525: ------------------ Get Balance Type IDs to update Flex Info ---------------

Line 581: update pay_element_types_f

577: end if;
578: --
579: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',17);
580: --
581: update pay_element_types_f
582: set element_information10 = l_pri_bal_id,
583: element_information11 = l_accr_bal_id,
584: element_information12 = l_arr_bal_id,
585: element_information13 = l_not_taken_bal_id,

Line 598: update pay_element_types_f

594: Process Date' for all Recurring Elements */
595:
596: If p_ele_processing_type = 'R' then
597:
598: update pay_element_types_f
599: set post_termination_rule = 'L'
600: where element_type_id = l_base_element_type_id
601: and business_group_id + 0 = p_bg_id;
602:

Line 1084: from pay_element_types_f

1080:
1081: --
1082: select element_type_id
1083: into l_base_element_type_id
1084: from pay_element_types_f
1085: where element_name = p_ele_name
1086: and business_group_id + 0 = p_bg_id;
1087: --
1088: select element_type_id

Line 1090: from pay_element_types_f

1086: and business_group_id + 0 = p_bg_id;
1087: --
1088: select element_type_id
1089: into l_fee_element_type_id
1090: from pay_element_types_f
1091: where element_name = p_ele_name||' Fees'
1092: and business_group_id + 0 = p_bg_id;
1093: --
1094: ------------------ Get Balance Type IDs to update Flex Info ---------------

Line 1165: update pay_element_types_f

1161: --
1162: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',17);
1163:
1164: --
1165: update pay_element_types_f
1166: set element_information10 = l_pri_bal_id,
1167: element_information11 = l_accr_bal_id,
1168: element_information12 = l_arr_bal_id,
1169: element_information13 = l_not_taken_bal_id,

Line 1179: update pay_element_types_f

1175: element_information20 = p_ele_registration_number
1176: where element_type_id = l_base_element_type_id
1177: and business_group_id + 0 = p_bg_id;
1178: --
1179: update pay_element_types_f
1180: set element_information10 = l_fees_bal_id
1181: where element_type_id = l_fee_element_type_id
1182: and business_group_id + 0 = p_bg_id;
1183: --

Line 1278: from pay_element_types_f

1274: --
1275: begin
1276: delete from pay_element_type_usages_f
1277: where element_type_id in ( select element_type_id
1278: from pay_element_types_f
1279: where element_name = p_ele_name
1280: and business_group_id = p_business_group_id );
1281: --
1282: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',3);

Line 1342: from pay_element_types_f

1338: --
1339: begin
1340: delete from pay_element_type_usages_f
1341: where element_type_id in ( select element_type_id
1342: from pay_element_types_f
1343: where element_name = p_ele_name
1344: and business_group_id = p_business_group_id );
1345: --
1346: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',3