DBA Data[Home] [Help]

APPS.GHR_API dependencies on PAY_INPUT_VALUES_F

Line 1655: ,p_input_value_name in pay_input_values_f.name%type

1651: -- ---------------------------------------------------------------------------
1652: --
1653: procedure retrieve_element_entry_value
1654: (p_element_name in pay_element_types_f.element_name%type
1655: ,p_input_value_name in pay_input_values_f.name%type
1656: ,p_assignment_id in pay_element_entries_f.assignment_id%type
1657: ,p_effective_date in date
1658: ,p_value OUT NOCOPY varchar2
1659: ,p_multiple_error_flag OUT NOCOPY boolean

Line 1688: pay_input_values_f ipv,

1684: ,eff_date in date
1685: ,bg_id in number) is
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

Line 1715: pay_input_values_f ipv,

1711: ,eff_date in date
1712: ,bg_id in number) is
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