DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_INPUT_VALUES_F

Line 182: ,pay_input_values_f piv

178: ,piv.uom
179: FROM hr_organization_information hoi
180: ,pay_element_classifications pec
181: ,pay_element_types_f pet
182: ,pay_input_values_f piv
183: WHERE hoi.organization_id = p_bus_grp_id
184: AND hoi.org_information_context = 'Business Group:Payslip Info'
185: AND hoi.org_information1 = 'ELEMENT'
186: AND hoi.org_information2 = pet.element_type_id

Line 1072: , pay_input_values_f iv

1068: ,iv.input_value_id input_value_id
1069: ,iv.uom uom
1070: FROM pay_element_types_f et
1071: , pay_element_types_f_tl pettl
1072: , pay_input_values_f iv
1073: , pay_element_classifications classification
1074: WHERE et.element_type_id = iv.element_type_id
1075: AND et.element_type_id = pettl.element_type_id
1076: AND pettl.language = USERENV('LANG')

Line 1104: , pay_input_values_f iv

1100: ,iv.input_value_id input_value_id
1101: ,iv.uom uom
1102: FROM pay_element_types_f et
1103: , pay_element_types_f_tl pettl
1104: , pay_input_values_f iv
1105: , pay_element_classifications classification
1106: WHERE et.element_type_id = iv.element_type_id
1107: AND et.element_type_id = pettl.element_type_id
1108: AND pettl.language = USERENV('LANG')

Line 1595: ,pay_input_values_f piv

1591: ,piv.uom
1592: FROM hr_organization_information hoi
1593: ,pay_element_classifications pec
1594: ,pay_element_types_f pet
1595: ,pay_input_values_f piv
1596: WHERE hoi.organization_id = p_bus_grp_id
1597: AND hoi.org_information_context = 'Business Group:Payslip Info'
1598: AND hoi.org_information1 = 'ELEMENT'
1599: AND hoi.org_information2 = pet.element_type_id

Line 1819: ,pay_input_values_f iv1

1815: ,per_all_assignments_f asg2
1816: ,per_all_people_f per
1817: ,pay_element_links_f el
1818: ,pay_element_types_f et
1819: ,pay_input_values_f iv1
1820: ,pay_element_entries_f ee
1821: ,pay_element_entry_values_f eev1
1822: WHERE asg1.assignment_id = p_assignment_id
1823: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 1847: ,pay_input_values_f iv1

1843: ,eev1.screen_entry_value screen_entry_value
1844: FROM per_all_assignments_f asg1
1845: ,pay_element_links_f el
1846: ,pay_element_types_f et
1847: ,pay_input_values_f iv1
1848: ,pay_element_entries_f ee
1849: ,pay_element_entry_values_f eev1
1850: WHERE asg1.assignment_id = p_assignment_id
1851: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 2725: , pay_input_values_f iv

2721: ,iv.input_value_id input_value_id
2722: ,iv.uom uom
2723: FROM pay_element_types_f et
2724: , pay_element_types_f_tl pettl
2725: , pay_input_values_f iv
2726: , pay_element_classifications classification
2727: WHERE et.element_type_id = iv.element_type_id
2728: AND et.element_type_id = pettl.element_type_id
2729: AND pettl.language = USERENV('LANG')

Line 2760: , pay_input_values_f iv

2756: ,iv.input_value_id input_value_id
2757: ,iv.uom uom
2758: FROM pay_element_types_f et
2759: , pay_element_types_f_tl pettl
2760: , pay_input_values_f iv
2761: , pay_element_classifications classification
2762: WHERE et.element_type_id = iv.element_type_id
2763: AND et.element_type_id = pettl.element_type_id
2764: AND pettl.language = USERENV('LANG')