APPS.HR_US_GARN_GEN dependencies on PAY_ELEMENT_TYPES_F

Line 617: update pay_element_types_f

613: ret := already_exists;
614:
615: /* Updating the processing priority of the elements */
616:
617: update pay_element_types_f
618: set processing_priority = p_ele_priority
619: where element_type_id = ret
620: and business_group_id + 0 = p_bg_id;
621:

Line 2470: UPDATE pay_element_types_f

2466: garn_payval_id(i) := v_payval_id;
2467:
2468: -- Update Element Type DDF as appropriate.
2469:
2470: UPDATE pay_element_types_f
2471: SET element_information_category = g_ele_info_cat,
2472: element_information1 = p_category,
2473: element_information2 = g_partial_dedn,
2474: element_information3 = g_ele_runtype,

Line 4892: UPDATE pay_element_types_f

4888: --
4889: -- Now make sure all DDF segs for assoc bals and assoc eles are set for
4890: -- child support.
4891: --
4892: UPDATE pay_element_types_f
4893: SET element_information5 = garn_ele_ids(2),
4894: element_information8 = garn_assoc_bal_ids(8),
4895: element_information10 = garn_assoc_bal_ids(1),
4896: element_information11 = garn_assoc_bal_ids(4),

Line 4916: UPDATE pay_element_types_f

4912: element_information20 = garn_ele_ids(3)
4913: WHERE element_type_id = garn_ele_ids(1);
4914:
4915: hr_utility.trace('Before final update Line:4513 garn_assoc_bal_id '|| to_char(garn_assoc_bal_ids(7)));
4916: UPDATE pay_element_types_f
4917: SET element_information10 = garn_assoc_bal_ids(7),
4918: element_information11 = garn_assoc_bal_ids(9)
4919: WHERE element_type_id = garn_ele_ids(6);
4920:

Line 5063: FROM pay_element_types_f

5059: -- Elements created prior to Garnishment Rewrite will return the
5060: -- element_type_id which is then used to delete the Priority element created.
5061: CURSOR c_get_priority IS
5062: SELECT element_type_id
5063: FROM pay_element_types_f
5064: WHERE element_name = p_ele_name||' Priority'
5065: AND p_del_sess_date between effective_start_date
5066: and effective_end_date
5067: AND business_group_id + 0 = p_business_group_id;

Line 5090: from pay_element_types_f

5086: select element_type_id
5087: , element_information11
5088: into l_fee_ele_id
5089: , l_fee_accrued_bal_id
5090: from pay_element_types_f
5091: where element_name = p_ele_name||' Fees'
5092: and p_del_sess_date between effective_start_date
5093: and effective_end_date
5094: and business_group_id + 0 = p_business_group_id ;

Line 5384: from pay_element_types_f

5380: IF assoc_eles(j) IS NOT NULL THEN
5381:
5382: select processing_priority
5383: into v_assoc_ele_priority
5384: from pay_element_types_f
5385: where element_type_id = assoc_eles(j)
5386: and v_del_sess_date between effective_start_date
5387: and effective_end_date;
5388:

Line 5411: delete from PAY_ELEMENT_TYPES_F

5407: -- Delete element type record:
5408: -- Remember, we're 'ZAP'ing, no need to worry about date-effective delete.
5409: --
5410: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 35);
5411: delete from PAY_ELEMENT_TYPES_F
5412: where element_type_id = assoc_eles(j);
5413:
5414: END IF;
5415: