DBA Data[Home] [Help]

APPS.GHR_API dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1690: pay_element_entry_values_f eev

1686: select eev.screen_entry_value screen_entry_value
1687: from pay_element_types_f elt,
1688: pay_input_values_f ipv,
1689: pay_element_entries_f ele,
1690: pay_element_entry_values_f eev
1691: where trunc(eff_date) between elt.effective_start_date
1692: and elt.effective_end_date
1693: and trunc(eff_date) between ipv.effective_start_date
1694: and ipv.effective_end_date

Line 1717: pay_element_entry_values_f eev

1713: select eev.screen_entry_value screen_entry_value
1714: from pay_element_types_f elt,
1715: pay_input_values_f ipv,
1716: pay_element_entries_f ele,
1717: pay_element_entry_values_f eev
1718: where trunc(eff_date) between elt.effective_start_date
1719: and elt.effective_end_date
1720: and trunc(eff_date) between ipv.effective_start_date
1721: and ipv.effective_end_date

Line 2685: l_element_entry_data pay_element_entry_values_f%rowtype;

2681: l_assignment_ddf_found boolean := FALSE;
2682: l_position_ddf_found boolean := FALSE;
2683: l_asg_ei_data per_assignment_extra_info%rowtype;
2684: l_pos_ei_data per_position_extra_info%rowtype;
2685: l_element_entry_data pay_element_entry_values_f%rowtype;
2686: l_org_id hr_organization_units.organization_id%type;
2687: --vsm
2688: l_business_group_id per_business_groups.business_group_id%type;
2689: l_result_code varchar2(30);