APPS.PQH_GL_POSTING dependencies on PAY_ELEMENT_LINKS

Line 2083: pay_element_links table , we only assign values for segments which are not null .

2079: First we will check to see if there are any defaults set for cost segments and if so populate the
2080: g_seg_val_tab with the defaults. Defaults are checks at the following level :
2081: payroll 1st level , we will first initialize the g_seg_val_tab and then get the defaults if any.
2082: element_link 2nd level, if for the position and element_type_id there are any defaults in the
2083: pay_element_links table , we only assign values for segments which are not null .
2084: organization 3rd level which will override the 1st level . At this level we only assign values
2085: which are not null
2086:
2087: The budget funding src level will override the above default values.

Line 3812: pay_element_links if the position id is not null at budget detail level. We would get the

3808: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE
3809: ) IS
3810: /*
3811: This procedure wil check if there are any defaults for the position and element in
3812: pay_element_links if the position id is not null at budget detail level. We would get the
3813: defaults from pay_element_links table and assign to g_seg_val_tab table
3814: We would only assign those segments which are not null. That way we would only override the segments
3815: which were set by payroll if the segment value at this level is not null.
3816: */

Line 3813: defaults from pay_element_links table and assign to g_seg_val_tab table

3809: ) IS
3810: /*
3811: This procedure wil check if there are any defaults for the position and element in
3812: pay_element_links if the position id is not null at budget detail level. We would get the
3813: defaults from pay_element_links table and assign to g_seg_val_tab table
3814: We would only assign those segments which are not null. That way we would only override the segments
3815: which were set by payroll if the segment value at this level is not null.
3816: */
3817:

Line 3830: pay_element_links pel

3826: CURSOR csr_cost_allocation_keyflex_id IS
3827: SELECT cost_allocation_keyflex_id
3828: FROM pqh_budget_details bdt, pqh_budget_periods bpr,
3829: pqh_budget_sets bst, pqh_budget_elements bel,
3830: pay_element_links pel
3831: WHERE bdt.budget_detail_id = bpr.budget_detail_id
3832: AND bpr.budget_period_id = bst.budget_period_id
3833: AND bst.budget_set_id = bel.budget_set_id
3834: AND bdt.position_id = pel.position_id