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

Line 150: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE

146: AND PAP.NATIONAL_IDENTIFIER = p_pin
147: AND PAA.PERSON_ID = PAP.PERSON_ID
148: AND PAA.PRIMARY_FLAG = 'Y'
149: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
150: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE
151: and PAA.EFFECTIVE_END_DATE
152: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE
153: and PAP.EFFECTIVE_END_DATE
154: AND SCL.ENABLED_FLAG = 'Y'

Line 152: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE

148: AND PAA.PRIMARY_FLAG = 'Y'
149: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
150: AND fnd_date.canonical_to_date(p_effective_date) between PAA.EFFECTIVE_START_DATE
151: and PAA.EFFECTIVE_END_DATE
152: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE
153: and PAP.EFFECTIVE_END_DATE
154: AND SCL.ENABLED_FLAG = 'Y'
155: AND SCL.SEGMENT2 in
156: (

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

170: and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
171: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
172: and hoi4.ORG_INFORMATION_CONTEXT='SE_LEGAL_EMPLOYER_DETAILS'
173: and hoi4.organization_id = hoi3.organization_id
174: and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
175: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date))
176: ) ;
177:
178: CURSOR csr_get_element_details(

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

171: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
172: and hoi4.ORG_INFORMATION_CONTEXT='SE_LEGAL_EMPLOYER_DETAILS'
173: and hoi4.organization_id = hoi3.organization_id
174: and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
175: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date))
176: ) ;
177:
178: CURSOR csr_get_element_details(
179: p_assignment_id per_all_assignments_f.assignment_id%TYPE

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

190: and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID
191: and paa.ASSIGNMENT_ID = pee.ASSIGNMENT_ID
192: and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
193: and pee.ASSIGNMENT_ID = p_assignment_id
194: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE
195: and pee.EFFECTIVE_END_DATE
196: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE
197: and pet.EFFECTIVE_END_DATE
198: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE

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

192: and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
193: and pee.ASSIGNMENT_ID = p_assignment_id
194: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE
195: and pee.EFFECTIVE_END_DATE
196: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE
197: and pet.EFFECTIVE_END_DATE
198: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE
199: and pel.EFFECTIVE_END_DATE
200: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE

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

194: and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE
195: and pee.EFFECTIVE_END_DATE
196: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE
197: and pet.EFFECTIVE_END_DATE
198: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE
199: and pel.EFFECTIVE_END_DATE
200: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE
201: and paa.EFFECTIVE_END_DATE ;
202:

Line 200: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE

196: and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE
197: and pet.EFFECTIVE_END_DATE
198: and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE
199: and pel.EFFECTIVE_END_DATE
200: and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE
201: and paa.EFFECTIVE_END_DATE ;
202:
203:
204: BEGIN

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

203:
204: BEGIN
205:
206: INSERT INTO fnd_sessions(SESSION_ID , EFFECTIVE_DATE )
207: VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;
208:
209: -- input parameters
210:
211: hr_utility.set_location('p_file_name '||p_file_name,1);

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

241: -- Create the Batch header
242: l_batch_id := hr_pump_utils.create_batch_header
243: (p_batch_name => p_batch_name,
244: p_business_group_name => l_bg_name,
245: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));
246:
247: hr_utility.set_location ( ' Batch ID = ' || l_batch_id, 40);
248:
249: -- Loop over the file, reading in each line. GET_LINE will

Line 402: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 193);

398: /* Initialize values for input value names of the seeded element */
399:
400: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 191);
401: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 192);
402: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 193);
403: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 194);
404:
405: -- Define Datetrack Updation Mode
406: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))

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

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

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

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

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

492:
493: hrdpp_create_element_entry.insert_batch_lines
494: (p_batch_id => l_batch_id
495: ,p_data_pump_business_grp_name => l_bg_name
496: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
497: ,P_ENTRY_TYPE => 'E'
498: ,P_CREATOR_TYPE => 'F'
499: ,P_ENTRY_VALUE1 => l_entry_value1
500: ,P_ENTRY_VALUE2 => l_entry_value2

Line 954: AND fnd_date.canonical_to_date(p_effective_date)

950: SELECT payroll_id
951: FROM per_all_assignments_f
952: WHERE business_group_id = p_business_group_id
953: AND assignment_id = p_assignment_id
954: AND fnd_date.canonical_to_date(p_effective_date)
955: BETWEEN effective_start_date AND effective_end_date ;
956:
957: Cursor csr_element_link_id
958: (