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

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

216: pay_in_utils.trace('g_session_date : ',g_session_date);
217: end if;
218:
219: i := TO_NUMBER(SUBSTR(g_quarter,2,1)) - 1;
220: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
221: g_tax_year := TO_CHAR((TO_NUMBER(SUBSTR(g_year,1,4)) - 1)||'-'||SUBSTR(g_year,1,4));
222: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
223:
224: if g_debug then

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

218:
219: i := TO_NUMBER(SUBSTR(g_quarter,2,1)) - 1;
220: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
221: g_tax_year := TO_CHAR((TO_NUMBER(SUBSTR(g_year,1,4)) - 1)||'-'||SUBSTR(g_year,1,4));
222: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
223:
224: if g_debug then
225: pay_in_utils.trace('i : ',i);
226: pay_in_utils.trace('l_assess_yr_start : ',l_assess_yr_start);

Line 401: AND peev.screen_entry_value in (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3

397: WHERE peev.input_value_id = g_input_table_rec(1).input_value_id
398: AND peev.element_entry_id = pee.element_entry_id
399: AND peev.effective_start_date <= g_fin_end_date
400: AND peev.effective_end_date >= g_fin_start_date
401: AND peev.screen_entry_value in (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
402: FROM hr_organization_units hou
403: ,hr_organization_information hoi
404: ,hr_organization_information bank
405: WHERE hoi.organization_id = hou.organization_id

Line 415: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3

411: AND hoi.org_information5 = bank.org_information_id
412: AND hoi.org_information13 = g_quarter
413: AND hoi.organization_id LIKE g_gre_id
414: UNION
415: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
416: FROM hr_organization_units hou
417: ,hr_organization_information hoi
418: WHERE hoi.organization_id = hou.organization_id
419: AND hou.business_group_id = g_bg_id

Line 528: AND fnd_date.canonical_to_date(hoi_challan.org_information2) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)

524: WHERE hoi_challan.organization_id = p_gre_id
525: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
526: AND hoi_challan.org_information1 = g_tax_year
527: AND hoi_challan.org_information13 = g_quarter
528: AND fnd_date.canonical_to_date(hoi_challan.org_information2) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)
529: ORDER BY fnd_date.canonical_to_date(hoi_challan.org_information2);
530:
531: CURSOR csr_challan_bank(p_bank_code VARCHAR2)
532: IS

Line 529: ORDER BY fnd_date.canonical_to_date(hoi_challan.org_information2);

525: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
526: AND hoi_challan.org_information1 = g_tax_year
527: AND hoi_challan.org_information13 = g_quarter
528: AND fnd_date.canonical_to_date(hoi_challan.org_information2) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)
529: ORDER BY fnd_date.canonical_to_date(hoi_challan.org_information2);
530:
531: CURSOR csr_challan_bank(p_bank_code VARCHAR2)
532: IS
533: SELECT hoi_bank.org_information4 Bank

Line 627: ,p_action_information1 => NVL(l_bank_code,'BOOK')||' - '||t_challan_entry_asg_tab(i).challan_number ||' - '||to_char(fnd_date.canonical_to_date(t_challan_entry_asg_tab(i).Payment_date),'DD-Mon-YYYY')

623: (p_action_context_id => p_arc_pay_action_id
624: ,p_action_context_type => 'PA'
625: ,p_action_information_category => 'IN_24Q_CHALLAN'
626: ,p_source_id => t_challan_entry_asg_tab(i).org_info_id
627: ,p_action_information1 => NVL(l_bank_code,'BOOK')||' - '||t_challan_entry_asg_tab(i).challan_number ||' - '||to_char(fnd_date.canonical_to_date(t_challan_entry_asg_tab(i).Payment_date),'DD-Mon-YYYY')
628: ,p_action_information2 => g_year||g_quarter
629: ,p_action_information3 => p_gre_id
630: ,p_action_information4 => l_bank_code
631: ,p_action_information5 => t_challan_entry_asg_tab(i).Payment_date

Line 747: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

743: AND hou.business_group_id = g_bg_id
744: AND pep.person_id = hoi.org_information1
745: AND pep.business_group_id = hou.business_group_id
746: AND p_effective_date BETWEEN pep.effective_start_date AND pep.effective_end_date
747: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
748: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
749: AND p_effective_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
750:
751: CURSOR c_rep_address(p_person_id NUMBER)

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

744: AND pep.person_id = hoi.org_information1
745: AND pep.business_group_id = hou.business_group_id
746: AND p_effective_date BETWEEN pep.effective_start_date AND pep.effective_end_date
747: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
748: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
749: AND p_effective_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
750:
751: CURSOR c_rep_address(p_person_id NUMBER)
752: IS

Line 1140: ,p_action_information9 => fnd_date.date_to_canonical(l_effective_start_date)

1136: ,p_action_information5 => p_person_table(1).pan_ref_number
1137: ,p_action_information6 => p_person_table(1).full_name
1138: ,p_action_information7 => p_person_table(1).tax_rate
1139: ,p_action_information8 => p_person_table(1).position
1140: ,p_action_information9 => fnd_date.date_to_canonical(l_effective_start_date)
1141: ,p_action_information10 => fnd_date.date_to_canonical(l_effective_end_date)
1142: ,p_action_information_id => l_action_info_id
1143: ,p_object_version_number => l_ovn
1144: );

Line 1141: ,p_action_information10 => fnd_date.date_to_canonical(l_effective_end_date)

1137: ,p_action_information6 => p_person_table(1).full_name
1138: ,p_action_information7 => p_person_table(1).tax_rate
1139: ,p_action_information8 => p_person_table(1).position
1140: ,p_action_information9 => fnd_date.date_to_canonical(l_effective_start_date)
1141: ,p_action_information10 => fnd_date.date_to_canonical(l_effective_end_date)
1142: ,p_action_information_id => l_action_info_id
1143: ,p_object_version_number => l_ovn
1144: );
1145:

Line 2283: AND peev.screen_entry_value LIKE '% - '|| hoi.org_information3|| ' - %'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR')

2279: FROM pay_element_entry_values_f peev
2280: ,hr_organization_information hoi
2281: WHERE peev.input_value_id = g_input_table_rec(1).input_value_id
2282: AND peev.element_entry_id = pee.element_entry_id
2283: AND peev.screen_entry_value LIKE '% - '|| hoi.org_information3|| ' - %'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR')
2284: AND hoi.organization_id = p_gre_id
2285: AND hoi.org_information1 = g_tax_year
2286: AND hoi.org_information13 = g_quarter
2287: AND hoi.org_information_context ='PER_IN_IT_CHALLAN_INFO'

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

2618: AND ROWNUM =1;
2619:
2620: CURSOR c_termination_check(p_assignment_id NUMBER)
2621: IS
2622: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2623: FROM per_all_assignments_f asg
2624: ,per_periods_of_service pos
2625: WHERE asg.person_id = pos.person_id
2626: AND asg.assignment_id = p_assignment_id