DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_INPUT_VALUES_F

Line 4000: pay_input_values_f piv

3996: from (select /*+ ORDERED */
3997: piv.element_type_id,
3998: piv.input_value_id
3999: from hr_organization_information hoi,
4000: pay_input_values_f piv
4001: where hoi.organization_id = g_itax_organization_id
4002: and hoi.org_information_context = 'JP_ITWB_ITEM_INFO'
4003: and hoi.org_information3 = 'IV'
4004: and fnd_number.canonical_to_number(hoi.org_information1) = p_data_ass_payroll_id

Line 4039: -- from pay_input_values_f piv

4035: ----
4036: -- cursor csr_elm_id
4037: -- is
4038: -- select piv.element_type_id
4039: -- from pay_input_values_f piv
4040: -- where piv.input_value_id = p_input_value_id;
4041: ----
4042: --begin
4043: ----