eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BF_BAL_UPLOAD dependencies on FND_DATE

Line 142: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')

138: p_assignment_id number
139: ,p_upload_date date
140: ) is
141: select nvl(trunc(p_upload_date -
142: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')
143: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),
144: END_OF_TIME)
145: from per_assignments_f ASS
146: ,hr_organization_information HOI

Line 143: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),

139: ,p_upload_date date
140: ) is
141: select nvl(trunc(p_upload_date -
142: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')
143: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),
144: END_OF_TIME)
145: from per_assignments_f ASS
146: ,hr_organization_information HOI
147: where ASS.assignment_id = p_assignment_id

Line 161: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -

157: p_assignment_id number
158: ,p_upload_date date
159: ) is
160: select nvl(add_months(trunc(add_months(p_upload_date, -
161: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -
162: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
163: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
164: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
165: END_OF_TIME)

Line 162: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),

158: ,p_upload_date date
159: ) is
160: select nvl(add_months(trunc(add_months(p_upload_date, -
161: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -
162: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
163: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
164: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
165: END_OF_TIME)
166: from per_assignments_f ASS

Line 163: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +

159: ) is
160: select nvl(add_months(trunc(add_months(p_upload_date, -
161: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -
162: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
163: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
164: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
165: END_OF_TIME)
166: from per_assignments_f ASS
167: ,hr_organization_information HOI

Line 164: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,

160: select nvl(add_months(trunc(add_months(p_upload_date, -
161: to_char(fnd_date.canonical_to_date(HOI.org_information11),'MM') + 1) -
162: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
163: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
164: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
165: END_OF_TIME)
166: from per_assignments_f ASS
167: ,hr_organization_information HOI
168: where ASS.assignment_id = p_assignment_id