DBA Data[Home] [Help]

APPS.GHR_ELT_TO_BEN_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 265: FROM pay_element_types_f a,pay_input_values_f b

261: AND (
262: (table_name = 'PER_PEOPLE_EXTRA_INFO' and information5 = 'GHR_US_PER_GROUP1') OR
263: (table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
264: AND information4 IN (SELECT b.input_value_id
265: FROM pay_element_types_f a,pay_input_values_f b
266: WHERE a.element_type_id = b.element_type_id
267: AND (
268: (a.element_name = 'FEGLI' AND b.NAME = 'Eligibility Expiration') OR
269: (a.element_name = 'Retirement Plan' AND b.NAME = 'FERS Eligibility Expires') OR

Line 338: FROM pay_element_types_f a,pay_input_values_f b

334: l_input_value_id NUMBER(20);
335:
336: CURSOR c_element_inpval(p_input_value_id NUMBER) IS
337: SELECT a.element_name element, b.name input_value
338: FROM pay_element_types_f a,pay_input_values_f b
339: WHERE a.element_type_id = b.element_type_id
340: AND b.input_value_id = p_input_value_id;
341:
342:

Line 691: from pay_element_types_f a,

687: e.assignment_id assignment_id,
688: c.business_group_id business_group_id,--Bug# 6735031
689: e.object_version_number object_version_number,
690: f.screen_entry_value screen_entry_value
691: from pay_element_types_f a,
692: pay_input_values_f b,
693: pay_element_links_f c,
694: pay_link_input_values_f d,
695: pay_element_entries_f e,

Line 723: from pay_element_types_f a,

719: e.assignment_id assignment_id,
720: c.business_group_id business_group_id, --Bug# 6735031
721: e.object_version_number object_version_number,
722: f.screen_entry_value screen_entry_value
723: from pay_element_types_f a,
724: pay_input_values_f b,
725: pay_element_links_f c,
726: pay_link_input_values_f d,
727: pay_element_entries_f e,

Line 754: from pay_element_types_f a,

750: e.element_entry_id element_entry_id,
751: e.assignment_id assignment_id,
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,

Line 786: from pay_element_types_f a,

782: e.element_entry_id element_entry_id,
783: e.assignment_id assignment_id,
784: e.object_version_number object_version_number,
785: f.screen_entry_value screen_entry_value
786: from pay_element_types_f a,
787: pay_input_values_f b,
788: pay_element_links_f c,
789: pay_link_input_values_f d,
790: pay_element_entries_f e,

Line 812: from pay_element_types_f a,

808:
809: cursor cur_hb_enroll is
810: select f.input_value_id input_value_id,
811: f.screen_entry_value screen_entry_value
812: from pay_element_types_f a,
813: pay_input_values_f b,
814: pay_element_links_f c,
815: pay_link_input_values_f d,
816: pay_element_entries_f e,

Line 839: from pay_element_types_f a,

835: select f.input_value_id input_value_id,
836: f.screen_entry_value screen_entry_value,
837: f.effective_start_date effective_start_date,
838: f.effective_end_date effective_end_date
839: from pay_element_types_f a,
840: pay_input_values_f b,
841: pay_element_links_f c,
842: pay_link_input_values_f d,
843: pay_element_entries_f e,

Line 1152: from pay_element_types_f a,

1148: e.assignment_id assignment_id,
1149: c.business_group_id business_group_id,--Bug# 6735031
1150: e.object_version_number object_version_number,
1151: f.screen_entry_value screen_entry_value
1152: from pay_element_types_f a,
1153: pay_input_values_f b,
1154: pay_element_links_f c,
1155: pay_link_input_values_f d,
1156: pay_element_entries_f e,

Line 1183: from pay_element_types_f a,

1179: e.assignment_id assignment_id,
1180: c.business_group_id business_group_id,--Bug# 6735031
1181: e.object_version_number object_version_number,
1182: f.screen_entry_value screen_entry_value
1183: from pay_element_types_f a,
1184: pay_input_values_f b,
1185: pay_element_links_f c,
1186: pay_link_input_values_f d,
1187: pay_element_entries_f e,

Line 1213: from pay_element_types_f a,

1209: e.element_entry_id element_entry_id,
1210: e.assignment_id assignment_id,
1211: e.object_version_number object_version_number,
1212: f.screen_entry_value screen_entry_value
1213: from pay_element_types_f a,
1214: pay_input_values_f b,
1215: pay_element_links_f c,
1216: pay_link_input_values_f d,
1217: pay_element_entries_f e,

Line 1244: from pay_element_types_f a,

1240: e.element_entry_id element_entry_id,
1241: e.assignment_id assignment_id,
1242: e.object_version_number object_version_number,
1243: f.screen_entry_value screen_entry_value
1244: from pay_element_types_f a,
1245: pay_input_values_f b,
1246: pay_element_links_f c,
1247: pay_link_input_values_f d,
1248: pay_element_entries_f e,

Line 1269: from pay_element_types_f a,

1265:
1266: cursor cur_hb_enroll is
1267: select f.input_value_id input_value_id,
1268: f.screen_entry_value screen_entry_value
1269: from pay_element_types_f a,
1270: pay_input_values_f b,
1271: pay_element_links_f c,
1272: pay_link_input_values_f d,
1273: pay_element_entries_f e,

Line 1296: from pay_element_types_f a,

1292: select f.input_value_id input_value_id,
1293: f.screen_entry_value screen_entry_value,
1294: f.effective_start_date effective_start_date,
1295: f.effective_end_date effective_end_date
1296: from pay_element_types_f a,
1297: pay_input_values_f b,
1298: pay_element_links_f c,
1299: pay_link_input_values_f d,
1300: pay_element_entries_f e,