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_FI_TC_DP_UPLOAD dependencies on FND_DATE

Line 153: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE

149: AND PAP.NATIONAL_IDENTIFIER = p_ni
150: AND PAA.PERSON_ID = PAP.PERSON_ID
151: AND PAA.PRIMARY_FLAG = 'Y'
152: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
153: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
154: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE
155: AND SCL.ENABLED_FLAG = 'Y'
156: AND SCL.SEGMENT2 in
157: ( select to_char(hoi1.organization_id)

Line 154: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE

150: AND PAA.PERSON_ID = PAP.PERSON_ID
151: AND PAA.PRIMARY_FLAG = 'Y'
152: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
153: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
154: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE
155: AND SCL.ENABLED_FLAG = 'Y'
156: AND SCL.SEGMENT2 in
157: ( select to_char(hoi1.organization_id)
158: from HR_ORGANIZATION_UNITS o1

Line 175: and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM

171: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
172: and hoi4.ORG_INFORMATION_CONTEXT='FI_LEGAL_EMPLOYER_DETAILS'
173: and hoi4.organization_id = hoi3.organization_id
174: and hoi4.org_information1 = SUBSTR(p_employer_org_no,1,9)
175: and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
176: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));
177:
178:
179:

Line 176: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));

172: and hoi4.ORG_INFORMATION_CONTEXT='FI_LEGAL_EMPLOYER_DETAILS'
173: and hoi4.organization_id = hoi3.organization_id
174: and hoi4.org_information1 = SUBSTR(p_employer_org_no,1,9)
175: and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
176: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));
177:
178:
179:
180: CURSOR csr_get_all_assg( p_business_group_id per_business_groups.business_group_id%TYPE

Line 193: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE

189: AND PAP.per_information_category ='FI'
190: AND PAP.NATIONAL_IDENTIFIER = p_ni
191: AND PAA.PERSON_ID = PAP.PERSON_ID
192: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
193: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
194: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE
195: AND SCL.ENABLED_FLAG = 'Y'
196: AND SCL.SEGMENT2 in
197: ( select to_char(hoi1.organization_id)

Line 194: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE

190: AND PAP.NATIONAL_IDENTIFIER = p_ni
191: AND PAA.PERSON_ID = PAP.PERSON_ID
192: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
193: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
194: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE
195: AND SCL.ENABLED_FLAG = 'Y'
196: AND SCL.SEGMENT2 in
197: ( select to_char(hoi1.organization_id)
198: from HR_ORGANIZATION_UNITS o1

Line 215: and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM

211: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
212: and hoi4.ORG_INFORMATION_CONTEXT='FI_LEGAL_EMPLOYER_DETAILS'
213: and hoi4.organization_id = hoi3.organization_id
214: and hoi4.org_information1 = SUBSTR(p_employer_org_no,1,9)
215: and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
216: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));
217:
218:
219:

Line 216: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));

212: and hoi4.ORG_INFORMATION_CONTEXT='FI_LEGAL_EMPLOYER_DETAILS'
213: and hoi4.organization_id = hoi3.organization_id
214: and hoi4.org_information1 = SUBSTR(p_employer_org_no,1,9)
215: and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
216: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));
217:
218:
219:
220: CURSOR csr_get_element_details

Line 236: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE

232: and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID
233: and paa.ASSIGNMENT_ID = pee.ASSIGNMENT_ID
234: and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
235: and pee.ASSIGNMENT_ID = p_assignment_id
236: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
237: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
238: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
239: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
240:

Line 237: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE

233: and paa.ASSIGNMENT_ID = pee.ASSIGNMENT_ID
234: and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
235: and pee.ASSIGNMENT_ID = p_assignment_id
236: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
237: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
238: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
239: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
240:
241: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)

Line 238: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE

234: and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
235: and pee.ASSIGNMENT_ID = p_assignment_id
236: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
237: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
238: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
239: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
240:
241: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
242: IS

Line 239: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;

235: and pee.ASSIGNMENT_ID = p_assignment_id
236: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
237: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
238: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
239: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
240:
241: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
242: IS
243: SELECT user_key_value, unique_key_id

Line 251: VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;

247:
248:
249: BEGIN
250: INSERT INTO fnd_sessions(SESSION_ID , EFFECTIVE_DATE )
251: VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;
252:
253: -- input parameters
254: hr_utility.set_location('p_file_name '||p_file_name,1);
255: hr_utility.set_location('p_effective_date '||p_effective_date,1);

Line 285: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));

281: -- Create the Batch header
282: l_batch_id := hr_pump_utils.create_batch_header
283: (p_batch_name => p_batch_name,
284: p_business_group_name => l_bg_name,
285: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));
286:
287: hr_utility.set_location ( ' Batch ID = ' || l_batch_id, 40);
288:
289: -- Loop over the file, reading in each line. GET_LINE will

Line 430: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 170);

426: hr_utility.set_location ( ' User Key added ' , 160);
427:
428: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 170);
429: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 170);
430: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 170);
431: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 170);
432:
433: -- Define Datetrack Updation Mode
434: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))

Line 434: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))

430: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 170);
431: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 170);
432:
433: -- Define Datetrack Updation Mode
434: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))
435: THEN
436: l_datetrack_update_mode := 'CORRECTION';
437: ELSIF(l_effective_end_date <> c_end_of_time)
438: THEN

Line 452: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)

448: hrdpp_update_element_entry.insert_batch_lines
449: (p_batch_id => l_batch_id
450: ,p_data_pump_business_grp_name => l_bg_name
451: ,P_DATETRACK_UPDATE_MODE => l_datetrack_update_mode
452: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
453: ,P_ENTRY_VALUE1 => l_entry_value1
454: ,P_ENTRY_VALUE2 => l_entry_value2
455: ,P_ENTRY_VALUE3 => l_entry_value3
456: ,P_ENTRY_VALUE4 => l_entry_value4

Line 527: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)

523:
524: hrdpp_create_element_entry.insert_batch_lines
525: (p_batch_id => l_batch_id
526: ,p_data_pump_business_grp_name => l_bg_name
527: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
528: ,P_ENTRY_TYPE => 'E'
529: ,P_CREATOR_TYPE => 'F'
530: ,P_ENTRY_VALUE1 => l_entry_value1
531: ,P_ENTRY_VALUE2 => l_entry_value2

Line 666: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 220);

662: hr_utility.set_location ( ' User Key added ' , 210);
663:
664: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 220);
665: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 220);
666: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 220);
667: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 220);
668:
669: -- Define Datetrack Updation Mode
670: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))

Line 670: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))

666: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 220);
667: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 220);
668:
669: -- Define Datetrack Updation Mode
670: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))
671: THEN
672: l_datetrack_update_mode := 'CORRECTION';
673: ELSIF(l_effective_end_date <> c_end_of_time)
674: THEN

Line 688: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)

684: hrdpp_update_element_entry.insert_batch_lines
685: (p_batch_id => l_batch_id
686: ,p_data_pump_business_grp_name => l_bg_name
687: ,P_DATETRACK_UPDATE_MODE => l_datetrack_update_mode
688: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
689: ,P_ENTRY_VALUE1 => l_t_entry_value1
690: ,P_ENTRY_VALUE2 => l_t_entry_value2
691: ,P_ENTRY_VALUE3 => l_t_entry_value3
692: ,P_ENTRY_VALUE4 => l_t_entry_value4

Line 1123: AND fnd_date.canonical_to_date(p_effective_date)

1119: SELECT payroll_id
1120: FROM per_all_assignments_f
1121: WHERE business_group_id = p_business_group_id
1122: AND assignment_id = p_assignment_id
1123: AND fnd_date.canonical_to_date(p_effective_date)
1124: BETWEEN effective_start_date AND effective_end_date ;
1125:
1126: Cursor csr_element_link_id
1127: (