APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_ELEMENT_TYPES_F

Line 102: from pay_element_types_f pet

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

Line 524: from pay_element_types_f

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

Line 584: update pay_element_types_f

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

Line 601: update pay_element_types_f

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

Line 1087: from pay_element_types_f

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

Line 1093: from pay_element_types_f

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

Line 1168: update pay_element_types_f

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

Line 1182: update pay_element_types_f

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

Line 1281: from pay_element_types_f

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

Line 1345: from pay_element_types_f

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