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

Line 480: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');

476: get_parameters(p_payroll_action_id,'RC' ,g_24qc_rep_adr_chg);
477: get_parameters(p_payroll_action_id,'RN' ,g_cancel_ref_number);
478:
479: i := TO_NUMBER(SUBSTR(g_quarter,2,1)) - 1;
480: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
481: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
482:
483: g_qr_start_date := ADD_MONTHS(l_assess_yr_start,(i*3)-12);
484: g_end_date := ADD_MONTHS(g_qr_start_date,3) -1;

Line 481: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');

477: get_parameters(p_payroll_action_id,'RN' ,g_cancel_ref_number);
478:
479: i := TO_NUMBER(SUBSTR(g_quarter,2,1)) - 1;
480: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
481: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
482:
483: g_qr_start_date := ADD_MONTHS(l_assess_yr_start,(i*3)-12);
484: g_end_date := ADD_MONTHS(g_qr_start_date,3) -1;
485:

Line 549: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))

545: RETURN DATE
546: IS
547: CURSOR c_termination_check
548: IS
549: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
550: FROM per_all_assignments_f asg
551: ,per_periods_of_service pos
552: WHERE asg.person_id = pos.person_id
553: AND asg.assignment_id = p_assignment_id

Line 2791: AND g_qr_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

2787: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2788: AND pep.person_id = hoi.org_information1
2789: AND pep.business_group_id = hou.business_group_id
2790: AND g_qr_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2791: AND g_qr_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
2792: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
2793: AND g_qr_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2794:
2795: CURSOR c_rep_phone(p_person_id NUMBER)

Line 2792: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))

2788: AND pep.person_id = hoi.org_information1
2789: AND pep.business_group_id = hou.business_group_id
2790: AND g_qr_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2791: AND g_qr_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
2792: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
2793: AND g_qr_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2794:
2795: CURSOR c_rep_phone(p_person_id NUMBER)
2796: IS

Line 4242: ,fnd_date.canonical_to_date(pai.action_information9) start_date

4238: pai.action_information1 person_id
4239: ,pai.action_information4 pan_number
4240: ,pai.action_information5 pan_ref_number
4241: ,pai.action_information6 full_name
4242: ,fnd_date.canonical_to_date(pai.action_information9) start_date
4243: ,fnd_date.canonical_to_date(pai.action_information10) end_date
4244: ,pai.source_id
4245: FROM pay_action_information pai
4246: ,pay_assignment_actions paa

Line 4243: ,fnd_date.canonical_to_date(pai.action_information10) end_date

4239: ,pai.action_information4 pan_number
4240: ,pai.action_information5 pan_ref_number
4241: ,pai.action_information6 full_name
4242: ,fnd_date.canonical_to_date(pai.action_information9) start_date
4243: ,fnd_date.canonical_to_date(pai.action_information10) end_date
4244: ,pai.source_id
4245: FROM pay_action_information pai
4246: ,pay_assignment_actions paa
4247: WHERE pai.action_information_category IN('IN_24Q_PERSON')

Line 4266: ,fnd_date.canonical_to_date(pai.action_information8) start_date

4262: pai.action_information1 person_id
4263: ,pai.action_information4 pan_number
4264: ,pai.action_information5 pan_ref_number
4265: ,pai.action_information6 full_name
4266: ,fnd_date.canonical_to_date(pai.action_information8) start_date
4267: ,fnd_date.canonical_to_date(pai.action_information9) end_date
4268: ,pai.source_id
4269: FROM pay_action_information pai
4270: ,pay_assignment_actions paa

Line 4267: ,fnd_date.canonical_to_date(pai.action_information9) end_date

4263: ,pai.action_information4 pan_number
4264: ,pai.action_information5 pan_ref_number
4265: ,pai.action_information6 full_name
4266: ,fnd_date.canonical_to_date(pai.action_information8) start_date
4267: ,fnd_date.canonical_to_date(pai.action_information9) end_date
4268: ,pai.source_id
4269: FROM pay_action_information pai
4270: ,pay_assignment_actions paa
4271: ,pay_action_interlocks locks

Line 4434: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))

4430: AND ROWNUM =1;
4431:
4432: CURSOR c_termination_check(p_assignment_id NUMBER)
4433: IS
4434: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
4435: FROM per_all_assignments_f asg
4436: ,per_periods_of_service pos
4437: WHERE asg.person_id = pos.person_id
4438: AND asg.assignment_id = p_assignment_id

Line 5304: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5300: ,p_action_information4 => tab_liv_pe_data.pan_number
5301: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5302: ,p_action_information6 => tab_liv_pe_data.full_name
5303: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5304: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5305: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5306: ,p_action_information10 => 'D'
5307: ,p_action_information11 => 'C4'
5308: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 5305: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5301: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5302: ,p_action_information6 => tab_liv_pe_data.full_name
5303: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5304: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5305: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5306: ,p_action_information10 => 'D'
5307: ,p_action_information11 => 'C4'
5308: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
5309: ,p_action_information_id => l_action_info_id

Line 5409: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5405: ,p_action_information4 => tab_liv_pe_data.pan_number
5406: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5407: ,p_action_information6 => tab_liv_pe_data.full_name
5408: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5409: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5410: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5411: ,p_action_information10 => 'A'
5412: ,p_action_information11 => 'C4'
5413: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s

Line 5410: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5406: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5407: ,p_action_information6 => tab_liv_pe_data.full_name
5408: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5409: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5410: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5411: ,p_action_information10 => 'A'
5412: ,p_action_information11 => 'C4'
5413: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s
5414: ,p_action_information_id => l_action_info_id

Line 5483: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5479: ,p_action_information4 => tab_liv_pe_data.pan_number
5480: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5481: ,p_action_information6 => tab_liv_pe_data.full_name
5482: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5483: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5484: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5485: ,p_action_information10 => 'NA'
5486: ,p_action_information11 => 'C5'
5487: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 5484: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5480: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5481: ,p_action_information6 => tab_liv_pe_data.full_name
5482: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5483: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5484: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5485: ,p_action_information10 => 'NA'
5486: ,p_action_information11 => 'C5'
5487: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
5488: ,p_action_information_id => l_action_info_id

Line 5687: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5683: ,p_action_information4 => tab_liv_pe_data.pan_number
5684: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5685: ,p_action_information6 => tab_liv_pe_data.full_name
5686: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5687: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5688: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5689: ,p_action_information10 => 'NA'
5690: ,p_action_information11 => 'C5'
5691: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 5688: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5684: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5685: ,p_action_information6 => tab_liv_pe_data.full_name
5686: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5687: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5688: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5689: ,p_action_information10 => 'NA'
5690: ,p_action_information11 => 'C5'
5691: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
5692: ,p_action_information_id => l_action_info_id

Line 5749: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5745: ,p_action_information4 => tab_liv_pe_data.pan_number
5746: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5747: ,p_action_information6 => tab_liv_pe_data.full_name
5748: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5749: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5750: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5751: ,p_action_information10 => 'A'
5752: ,p_action_information11 => 'C4'
5753: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s

Line 5750: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5746: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5747: ,p_action_information6 => tab_liv_pe_data.full_name
5748: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5749: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5750: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5751: ,p_action_information10 => 'A'
5752: ,p_action_information11 => 'C4'
5753: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s
5754: ,p_action_information_id => l_action_info_id

Line 5856: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5852: ,p_action_information4 => tab_liv_pe_data.pan_number
5853: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5854: ,p_action_information6 => tab_liv_pe_data.full_name
5855: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5856: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5857: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5858: ,p_action_information10 => 'D'
5859: ,p_action_information11 => 'C4'
5860: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 5857: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5853: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5854: ,p_action_information6 => tab_liv_pe_data.full_name
5855: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5856: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5857: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5858: ,p_action_information10 => 'D'
5859: ,p_action_information11 => 'C4'
5860: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
5861: ,p_action_information_id => l_action_info_id

Line 6061: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6057: ,p_action_information4 => tab_liv_pe_data.pan_number
6058: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6059: ,p_action_information6 => tab_liv_pe_data.full_name
6060: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6061: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6062: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6063: ,p_action_information10 => 'NA'
6064: ,p_action_information11 => 'C5'
6065: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 6062: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6058: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6059: ,p_action_information6 => tab_liv_pe_data.full_name
6060: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6061: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6062: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6063: ,p_action_information10 => 'NA'
6064: ,p_action_information11 => 'C5'
6065: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
6066: ,p_action_information_id => l_action_info_id

Line 6111: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6107: ,p_action_information4 => tab_liv_pe_data.pan_number
6108: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6109: ,p_action_information6 => tab_liv_pe_data.full_name
6110: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6111: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6112: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6113: ,p_action_information10 => 'D'
6114: ,p_action_information11 => 'C4'
6115: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 6112: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6108: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6109: ,p_action_information6 => tab_liv_pe_data.full_name
6110: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6111: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6112: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6113: ,p_action_information10 => 'D'
6114: ,p_action_information11 => 'C4'
6115: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
6116: ,p_action_information_id => l_action_info_id

Line 6203: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6199: ,p_action_information4 => tab_liv_pe_data.pan_number
6200: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6201: ,p_action_information6 => tab_liv_pe_data.full_name
6202: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6203: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6204: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6205: ,p_action_information10 => 'A'
6206: ,p_action_information11 => 'C4'
6207: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s

Line 6204: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6200: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6201: ,p_action_information6 => tab_liv_pe_data.full_name
6202: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6203: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6204: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6205: ,p_action_information10 => 'A'
6206: ,p_action_information11 => 'C4'
6207: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s
6208: ,p_action_information_id => l_action_info_id