DBA Data[Home] [Help]

APPS.GHR_ELT_TO_BEN_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 724: pay_element_links_f c,

720: e.object_version_number object_version_number,
721: f.screen_entry_value screen_entry_value
722: from pay_element_types_f a,
723: pay_input_values_f b,
724: pay_element_links_f c,
725: pay_link_input_values_f d,
726: pay_element_entries_f e,
727: pay_element_entry_values_f f
728: where a.element_type_id = b.element_type_id

Line 756: pay_element_links_f c,

752: e.object_version_number object_version_number,
753: f.screen_entry_value screen_entry_value
754: from pay_element_types_f a,
755: pay_input_values_f b,
756: pay_element_links_f c,
757: pay_link_input_values_f d,
758: pay_element_entries_f e,
759: pay_element_entry_values_f f
760: where a.element_type_id = b.element_type_id

Line 787: pay_element_links_f c,

783: e.object_version_number object_version_number,
784: f.screen_entry_value screen_entry_value
785: from pay_element_types_f a,
786: pay_input_values_f b,
787: pay_element_links_f c,
788: pay_link_input_values_f d,
789: pay_element_entries_f e,
790: pay_element_entry_values_f f
791: where a.element_type_id = b.element_type_id

Line 819: pay_element_links_f c,

815: e.object_version_number object_version_number,
816: f.screen_entry_value screen_entry_value
817: from pay_element_types_f a,
818: pay_input_values_f b,
819: pay_element_links_f c,
820: pay_link_input_values_f d,
821: pay_element_entries_f e,
822: pay_element_entry_values_f f
823: where a.element_type_id = b.element_type_id

Line 845: pay_element_links_f c,

841: select f.input_value_id input_value_id,
842: f.screen_entry_value screen_entry_value
843: from pay_element_types_f a,
844: pay_input_values_f b,
845: pay_element_links_f c,
846: pay_link_input_values_f d,
847: pay_element_entries_f e,
848: pay_element_entry_values_f f
849: where a.element_type_id = b.element_type_id

Line 872: pay_element_links_f c,

868: f.effective_start_date effective_start_date,
869: f.effective_end_date effective_end_date
870: from pay_element_types_f a,
871: pay_input_values_f b,
872: pay_element_links_f c,
873: pay_link_input_values_f d,
874: pay_element_entries_f e,
875: pay_element_entry_values_f f
876: where a.element_type_id = b.element_type_id

Line 1177: pay_element_links_f c,

1173: e.object_version_number object_version_number,
1174: f.screen_entry_value screen_entry_value
1175: from pay_element_types_f a,
1176: pay_input_values_f b,
1177: pay_element_links_f c,
1178: pay_link_input_values_f d,
1179: pay_element_entries_f e,
1180: pay_element_entry_values_f f
1181: where a.element_type_id = b.element_type_id

Line 1208: pay_element_links_f c,

1204: e.object_version_number object_version_number,
1205: f.screen_entry_value screen_entry_value
1206: from pay_element_types_f a,
1207: pay_input_values_f b,
1208: pay_element_links_f c,
1209: pay_link_input_values_f d,
1210: pay_element_entries_f e,
1211: pay_element_entry_values_f f
1212: where a.element_type_id = b.element_type_id

Line 1238: pay_element_links_f c,

1234: e.object_version_number object_version_number,
1235: f.screen_entry_value screen_entry_value
1236: from pay_element_types_f a,
1237: pay_input_values_f b,
1238: pay_element_links_f c,
1239: pay_link_input_values_f d,
1240: pay_element_entries_f e,
1241: pay_element_entry_values_f f
1242: where a.element_type_id = b.element_type_id

Line 1269: pay_element_links_f c,

1265: e.object_version_number object_version_number,
1266: f.screen_entry_value screen_entry_value
1267: from pay_element_types_f a,
1268: pay_input_values_f b,
1269: pay_element_links_f c,
1270: pay_link_input_values_f d,
1271: pay_element_entries_f e,
1272: pay_element_entry_values_f f
1273: where a.element_type_id = b.element_type_id

Line 1294: pay_element_links_f c,

1290: select f.input_value_id input_value_id,
1291: f.screen_entry_value screen_entry_value
1292: from pay_element_types_f a,
1293: pay_input_values_f b,
1294: pay_element_links_f c,
1295: pay_link_input_values_f d,
1296: pay_element_entries_f e,
1297: pay_element_entry_values_f f
1298: where a.element_type_id = b.element_type_id

Line 1321: pay_element_links_f c,

1317: f.effective_start_date effective_start_date,
1318: f.effective_end_date effective_end_date
1319: from pay_element_types_f a,
1320: pay_input_values_f b,
1321: pay_element_links_f c,
1322: pay_link_input_values_f d,
1323: pay_element_entries_f e,
1324: pay_element_entry_values_f f
1325: where a.element_type_id = b.element_type_id

Line 1631: pay_element_links_f c,

1627: e.object_version_number object_version_number,
1628: f.screen_entry_value screen_entry_value
1629: from pay_element_types_f a,
1630: pay_input_values_f b,
1631: pay_element_links_f c,
1632: pay_link_input_values_f d,
1633: pay_element_entries_f e,
1634: pay_element_entry_values_f f
1635: where a.element_type_id = b.element_type_id

Line 1662: pay_element_links_f c,

1658: e.object_version_number object_version_number,
1659: f.screen_entry_value screen_entry_value
1660: from pay_element_types_f a,
1661: pay_input_values_f b,
1662: pay_element_links_f c,
1663: pay_link_input_values_f d,
1664: pay_element_entries_f e,
1665: pay_element_entry_values_f f
1666: where a.element_type_id = b.element_type_id

Line 1692: pay_element_links_f c,

1688: e.object_version_number object_version_number,
1689: f.screen_entry_value screen_entry_value
1690: from pay_element_types_f a,
1691: pay_input_values_f b,
1692: pay_element_links_f c,
1693: pay_link_input_values_f d,
1694: pay_element_entries_f e,
1695: pay_element_entry_values_f f
1696: where a.element_type_id = b.element_type_id

Line 1723: pay_element_links_f c,

1719: e.object_version_number object_version_number,
1720: f.screen_entry_value screen_entry_value
1721: from pay_element_types_f a,
1722: pay_input_values_f b,
1723: pay_element_links_f c,
1724: pay_link_input_values_f d,
1725: pay_element_entries_f e,
1726: pay_element_entry_values_f f
1727: where a.element_type_id = b.element_type_id

Line 1748: pay_element_links_f c,

1744: select f.input_value_id input_value_id,
1745: f.screen_entry_value screen_entry_value
1746: from pay_element_types_f a,
1747: pay_input_values_f b,
1748: pay_element_links_f c,
1749: pay_link_input_values_f d,
1750: pay_element_entries_f e,
1751: pay_element_entry_values_f f
1752: where a.element_type_id = b.element_type_id

Line 1775: pay_element_links_f c,

1771: f.effective_start_date effective_start_date,
1772: f.effective_end_date effective_end_date
1773: from pay_element_types_f a,
1774: pay_input_values_f b,
1775: pay_element_links_f c,
1776: pay_link_input_values_f d,
1777: pay_element_entries_f e,
1778: pay_element_entry_values_f f
1779: where a.element_type_id = b.element_type_id

Line 2155: pay_element_links_f c,

2151: e.object_version_number object_version_number,
2152: f.screen_entry_value screen_entry_value
2153: from pay_element_types_f a,
2154: pay_input_values_f b,
2155: pay_element_links_f c,
2156: pay_link_input_values_f d,
2157: pay_element_entries_f e,
2158: pay_element_entry_values_f f
2159: where a.element_type_id = b.element_type_id

Line 2185: pay_element_links_f c,

2181: e.object_version_number object_version_number,
2182: f.screen_entry_value screen_entry_value
2183: from pay_element_types_f a,
2184: pay_input_values_f b,
2185: pay_element_links_f c,
2186: pay_link_input_values_f d,
2187: pay_element_entries_f e,
2188: pay_element_entry_values_f f
2189: where a.element_type_id = b.element_type_id

Line 2210: pay_element_links_f c,

2206: CURSOR c_get_tsp_date IS
2207: select f.screen_entry_value screen_entry_value
2208: from pay_element_types_f a,
2209: pay_input_values_f b,
2210: pay_element_links_f c,
2211: pay_link_input_values_f d,
2212: pay_element_entries_f e,
2213: pay_element_entry_values_f f
2214: where a.element_type_id = b.element_type_id