APPS.PER_PTU_DFF_MIG dependencies on PER_PTU_DFF_MAPPING_LINES

Line 451: TYPE ATTR_TABLE_TYPE IS TABLE OF PER_PTU_DFF_MAPPING_LINES%ROWTYPE

447: p_person_rec_context varchar2)
448: RETURN PER_PERSON_TYPE_USAGES_F%ROWTYPE
449: IS
450: --
451: TYPE ATTR_TABLE_TYPE IS TABLE OF PER_PTU_DFF_MAPPING_LINES%ROWTYPE
452: INDEX BY BINARY_INTEGER;
453: --
454: l_attr_table ATTR_TABLE_TYPE;
455: --

Line 473: PER_PTU_DFF_MAPPING_LINES L

469: L.PTU_DFF_CONTEXT_FIELD_CODE,
470: L.PTU_DFF_ATTRIBUTE,
471: TO_NUMBER (SUBSTR (L.PER_DFF_ATTRIBUTE,10)) ATTRIBUTE_NUM
472: FROM PER_PTU_DFF_MAPPING_HEADERS H,
473: PER_PTU_DFF_MAPPING_LINES L
474: WHERE H.MAPPING_HEADER_ID = L.MAPPING_HEADER_ID
475: AND H.DATA_MAPPING_COMPLETE = 'Y'
476: AND H.PER_DFF_CONTEXT_FIELD_CODE =
477: NVL (p_person_rec_context, 'Global Data Elements')

Line 678: FROM PER_PTU_DFF_MAPPING_LINES L,

674: --
675: BEGIN
676: --
677: FOR attr_rec IN (SELECT L.PER_DFF_ATTRIBUTE
678: FROM PER_PTU_DFF_MAPPING_LINES L,
679: PER_PTU_DFF_MAPPING_HEADERS H
680: WHERE H.MAPPING_HEADER_ID = L.MAPPING_HEADER_ID
681: AND H.DATA_MAPPING_COMPLETE = 'Y'
682: AND L.PTU_DFF_CONTEXT_FIELD_CODE in

Line 716: ,per_ptu_dff_mapping_lines ml

712: --
713: CURSOR csr_basic_ptu_data(p_context varchar2) IS
714: SELECT distinct ptu_dff_context_field_code
715: FROM per_ptu_dff_mapping_headers mh
716: ,per_ptu_dff_mapping_lines ml
717: WHERE mh.mapping_header_id = ml.mapping_header_id
718: AND mh.per_dff_context_field_code = p_context
719: AND ml.ptu_dff_context_field_code <> 'Global Data Elements';
720: --

Line 1554: FROM PER_PTU_DFF_MAPPING_LINES L,

1550: --
1551: BEGIN
1552: --
1553: FOR attr_rec IN (SELECT L.PER_DFF_ATTRIBUTE
1554: FROM PER_PTU_DFF_MAPPING_LINES L,
1555: PER_PTU_DFF_MAPPING_HEADERS H
1556: WHERE H.MAPPING_HEADER_ID = L.MAPPING_HEADER_ID
1557: AND H.DATA_MAPPING_COMPLETE = 'Y'
1558: AND H.PER_DFF_CONTEXT_FIELD_CODE IN

Line 1707: FROM PER_PTU_DFF_MAPPING_LINES L

1703: FROM PER_PTU_DFF_MAPPING_HEADERS H
1704: WHERE H.DATA_MAPPING_COMPLETE = 'Y'
1705: AND EXISTS
1706: (SELECT 1
1707: FROM PER_PTU_DFF_MAPPING_LINES L
1708: WHERE H.MAPPING_HEADER_ID = L.MAPPING_HEADER_ID))
1709: AND EXISTS
1710: (SELECT 1
1711: FROM PAY_ASSIGNMENT_ACTIONS ASS

Line 2544: INSERT INTO PER_PTU_DFF_MAPPING_LINES

2540: AND FDFV.DESCRIPTIVE_FLEXFIELD_NAME = 'PER_PEOPLE';
2541: --
2542: -- Populate Lines table which holds the attribute usage details.
2543: --
2544: INSERT INTO PER_PTU_DFF_MAPPING_LINES
2545: ( MAPPING_LINE_ID,
2546: MAPPING_HEADER_ID,
2547: PER_DFF_ATTRIBUTE,
2548: PER_END_USER_COLUMN_NAME,

Line 2558: SELECT PER_PTU_DFF_MAPPING_LINES_S.nextval,

2554: CREATION_DATE,
2555: LAST_UPDATED_BY,
2556: LAST_UPDATE_DATE,
2557: LAST_UPDATE_LOGIN )
2558: SELECT PER_PTU_DFF_MAPPING_LINES_S.nextval,
2559: MH.MAPPING_HEADER_ID,
2560: FDFU.APPLICATION_COLUMN_NAME,
2561: FDFU.END_USER_COLUMN_NAME,
2562: NULL, -- PTU_DFF_CONTEXT_FIELD_CODE