APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on FND_DATE

Line 15: ('SS_DATE=P'), to_char(fnd_date.canonical_to_date(pact.action_information3), 'YYYYMMDD'),

11: --------------------------------------------------------------------------------
12: CURSOR CSR_SS_REP_HEADER_FOOTER IS
13: SELECT ('AUTHORIZATION_KEY=P'), LPAD(NVL(pact.action_information1,'0'), 8, '0'),
14: ('SILCON_KEY=P'), RPAD(NVL(pact.action_information2,' '), 8,' '),
15: ('SS_DATE=P'), to_char(fnd_date.canonical_to_date(pact.action_information3), 'YYYYMMDD'),
16: ('SS_TIME=P'), LPAD(NVL(pact.action_information4,'0'), 4, '0'),
17: ('FILE_NAME=P'), to_char(fnd_date.canonical_to_date(pact.action_information5), 'YYYYMMDD'),
18: ('FILE_EXTENSION=P'), RPAD(pact.action_information6, 3),
19: ('TEST_FLAG=P'), pact.action_information8,

Line 17: ('FILE_NAME=P'), to_char(fnd_date.canonical_to_date(pact.action_information5), 'YYYYMMDD'),

13: SELECT ('AUTHORIZATION_KEY=P'), LPAD(NVL(pact.action_information1,'0'), 8, '0'),
14: ('SILCON_KEY=P'), RPAD(NVL(pact.action_information2,' '), 8,' '),
15: ('SS_DATE=P'), to_char(fnd_date.canonical_to_date(pact.action_information3), 'YYYYMMDD'),
16: ('SS_TIME=P'), LPAD(NVL(pact.action_information4,'0'), 4, '0'),
17: ('FILE_NAME=P'), to_char(fnd_date.canonical_to_date(pact.action_information5), 'YYYYMMDD'),
18: ('FILE_EXTENSION=P'), RPAD(pact.action_information6, 3),
19: ('TEST_FLAG=P'), pact.action_information8,
20: ('CURRENT_PASSWORD=P'), RPAD(NVL(pact.action_information9,' '), 8),
21: ('NEW_PASSWORD=P'), RPAD(NVL(pact.action_information10,' '), 8)

Line 79: ('ACTUAL_DATE=P'), to_char(fnd_date.canonical_to_date(pact_fab.action_information3), 'YYYYMMDD'),

75: ('SECOND_LAST_NAME=P'), RPAD(NVL(pact_tra.action_information8,' '), 20,' '),
76: ('SS_NAME=P'), RPAD(NVL(pact_tra.action_information9,' '), 15,' '),
77: ('ACTION=P'), pact_fab.action_information1,
78: ('STATUS_OF_REASON=P'), LPAD(NVL(pact_fab.action_information2,'0'), 2, '0'),
79: ('ACTUAL_DATE=P'), to_char(fnd_date.canonical_to_date(pact_fab.action_information3), 'YYYYMMDD'),
80: ('ASSIGNMENT_STATUS=P'), LPAD(NVL(pact_fab.action_information4,'0'), 2, '0'),
81: ('EMPLOYMENT_CATEGORY=P'), LPAD(NVL(pact_fab.action_information5,'0'), 3, '0'),
82: ('EPIGRAPH_CODE=P'), LPAD(NVL(pact_fab.action_information6,'0'), 3, '0'),
83: ('UNEMPLOYED_FLAG=P'), NVL(pact_fab.action_information7,'0'),

Line 89: ('BIRTH_DATE=P'), NVL(to_char(fnd_date.canonical_to_date(pact_fab.action_information9), 'YYYYMMDD'),'0'),

85: ('PART_TIME_PERCENT=P'), LPAD(NVL(pact_fab.action_information19,'0'), 3, '0'),
86: ('EMP_COLLECTIVE_AGREEMENT=P'), LPAD(NVL(pact_fab.action_information20,'0'), 3, '0'),
87: ('PRINT_FLAG=P'), ' ',
88: ('PROFESSIONAL_CATEGORY=P'), LPAD(NVL(pact_fab.action_information21,'0'), 7, '0'),
89: ('BIRTH_DATE=P'), NVL(to_char(fnd_date.canonical_to_date(pact_fab.action_information9), 'YYYYMMDD'),'0'),
90: ('SEX=P'), DECODE(NVL(pact_fab.action_information10,'0'),'M','1','F','2','0') ,
91: ('RE_HIRED_DISABLED_FLAG=P'), DECODE(NVL(pact_fab.action_information11,' '),'Y','S','N','N',' '),
92: ('INDEPENDENT_CONTRACTOR=P'), DECODE(NVL(pact_fab.action_information12,' '),'Y','S','N','N',' '),
93: ('DISABILITY_DEGREE=P'), RPAD(NVL(pact_fab.action_information13,' '), 2),

Line 100: ('CONT_START_DATE=P'),LPAD(NVL(to_char(fnd_date.canonical_to_date(pact_tra.action_information12), 'YYYYMMDD'),'0'),8,'0'),

96: ('EMP_ACTIVE_RENT_FLAG=P'), DECODE(NVL(pact_fab.action_information16,' '),'Y','S','N','N',' '),
97: ('EMP_MATERNITY_LEAVE=P'), DECODE(NVL(pact_fab.action_information17,' '),'Y','S','N','N',' '),
98: ('CONTRIBUTION_GROUP=P'), LPAD(NVL(pact_fab.action_information18,'0'),2,'0'),
99: ('ASS_NUMBER=P'), pact_tra.action_information10,
100: ('CONT_START_DATE=P'),LPAD(NVL(to_char(fnd_date.canonical_to_date(pact_tra.action_information12), 'YYYYMMDD'),'0'),8,'0'),
101: ('CONT_START_FLAG=P'),DECODE(NVL(pact_tra.action_information13,'N'),'N','N','Y'),
102: ('LABOR_RELATIONSHIP_TYPE=P'), LPAD(NVL(pact_tra.action_information14,'0'),4,'0'),
103: ('REPLACED_EMP_SS_NO=P'),LPAD(NVL(pact_tra.action_information15,'0'),12,'0'),
104: ('REPLACEMENT_REASON=P'),LPAD(NVL(pact_tra.action_information16,'0'),2,'0'),