APPS.PSP_ORG_DLS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 87: from PSP_ELEMENT_TYPES a, PAY_ELEMENT_TYPES_F b

83: --Resetting the Batch Sequence Number
84: p_Batch_Sequence_Number := NULL;
85:
86: g_element_type_id_str := '( Select DISTINCT a.ELEMENT_TYPE_ID
87: from PSP_ELEMENT_TYPES a, PAY_ELEMENT_TYPES_F b
88: where a.ELEMENT_TYPE_ID = b.ELEMENT_TYPE_ID
89: AND a.business_group_id = ' || p_business_group_id || '
90: AND a.set_of_books_id = ' || p_set_of_books_id || ')' ;
91:

Line 1254: PAY_ELEMENT_TYPES_F d,

1250: Select DISTINCT e.Start_Date_Active, e.End_Date_Active
1251: from PER_ASSIGNMENTS_F a,
1252: PAY_ELEMENT_ENTRIES_F b,
1253: PAY_ELEMENT_LINKS_F c,
1254: PAY_ELEMENT_TYPES_F d,
1255: PSP_ELEMENT_TYPE_ACCOUNTS e
1256: where a.ASSIGNMENT_ID = b.ASSIGNMENT_ID
1257: and b.ELEMENT_LINK_ID = c.ELEMENT_LINK_ID
1258: and c.ELEMENT_TYPE_ID = d.ELEMENT_TYPE_ID