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

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

138: AND PAP.per_information_category ='NO'
139: AND PAP.NATIONAL_IDENTIFIER = p_ni
140: AND PAA.PERSON_ID = PAP.PERSON_ID
141: AND PAA.PRIMARY_FLAG = 'Y'
142: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
143: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE ;
144:
145:
146:

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

139: AND PAP.NATIONAL_IDENTIFIER = p_ni
140: AND PAA.PERSON_ID = PAP.PERSON_ID
141: AND PAA.PRIMARY_FLAG = 'Y'
142: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
143: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE ;
144:
145:
146:
147: CURSOR csr_get_element_details(p_assignment_id per_all_assignments_f.assignment_id%TYPE )

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

157: and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID
158: and paa.ASSIGNMENT_ID = pee.ASSIGNMENT_ID
159: and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
160: and pee.ASSIGNMENT_ID = p_assignment_id
161: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
162: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
163: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
164: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
165:

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

158: and paa.ASSIGNMENT_ID = pee.ASSIGNMENT_ID
159: and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
160: and pee.ASSIGNMENT_ID = p_assignment_id
161: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
162: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
163: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
164: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
165:
166: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)

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

159: and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
160: and pee.ASSIGNMENT_ID = p_assignment_id
161: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
162: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
163: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
164: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
165:
166: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
167: IS

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

160: and pee.ASSIGNMENT_ID = p_assignment_id
161: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
162: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
163: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
164: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
165:
166: CURSOR csr_get_user_key(p_user_key_value hr_pump_batch_line_user_keys.user_key_value%type)
167: IS
168: SELECT user_key_value, unique_key_id

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

178: l_batch_seq := 0;
179:
180:
181: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
182: VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;
183:
184:
185: hr_utility.set_location('p_file_name '||p_file_name,1);
186: hr_utility.set_location('p_effective_date '||p_effective_date,1);

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

211: -- Create the Batch header
212: l_batch_id := hr_pump_utils.create_batch_header
213: (p_batch_name => p_batch_name,
214: p_business_group_name => l_bg_name,
215: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));
216:
217: hr_utility.set_location ( ' Batch ID = ' || l_batch_id, 40);
218:
219: -- Loop over the file, reading in each line. GET_LINE will

Line 406: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 90);

402: hr_utility.set_location ( ' User Key added ' , 80);
403:
404: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 90);
405: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 90);
406: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 90);
407: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 90);
408:
409: -- Define Datetrack Updation Mode
410: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))

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

406: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 90);
407: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 90);
408:
409: -- Define Datetrack Updation Mode
410: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))
411: THEN
412: l_datetrack_update_mode := 'CORRECTION';
413: ELSIF(l_effective_end_date <> c_end_of_time)
414: THEN

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

424: hrdpp_update_element_entry.insert_batch_lines
425: (p_batch_id => l_batch_id
426: ,p_data_pump_business_grp_name => l_bg_name
427: ,P_DATETRACK_UPDATE_MODE => l_datetrack_update_mode
428: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
429: ,P_ENTRY_VALUE1 => l_entry_value1
430: ,P_ENTRY_VALUE2 => l_entry_value2
431: ,P_ENTRY_VALUE3 => l_entry_value3
432: ,P_ENTRY_VALUE4 => l_entry_value4

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

500:
501: hrdpp_create_element_entry.insert_batch_lines
502: (p_batch_id => l_batch_id
503: ,p_data_pump_business_grp_name => l_bg_name
504: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
505: ,P_ENTRY_TYPE => 'E'
506: ,P_CREATOR_TYPE => 'F'
507: ,P_ENTRY_VALUE1 => l_entry_value1
508: ,P_ENTRY_VALUE2 => l_entry_value2

Line 1001: AND fnd_date.canonical_to_date(p_effective_date)

997: SELECT payroll_id
998: FROM per_all_assignments_f
999: WHERE business_group_id = p_business_group_id
1000: AND assignment_id = p_assignment_id
1001: AND fnd_date.canonical_to_date(p_effective_date)
1002: BETWEEN effective_start_date AND effective_end_date ;
1003:
1004: Cursor csr_element_link_id
1005: (