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 404: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 90);

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

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

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

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

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

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

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

Line 998: AND fnd_date.canonical_to_date(p_effective_date)

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