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 221: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');

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

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

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

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

506: WHERE hoi_challan.organization_id = p_gre_id
507: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
508: AND hoi_challan.org_information1 = g_tax_year
509: AND hoi_challan.org_information13 = g_quarter
510: AND fnd_date.canonical_to_date(hoi_challan.org_information2) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)
511: ORDER BY fnd_date.canonical_to_date(hoi_challan.org_information2);
512:
513: CURSOR csr_challan_bank(p_bank_code VARCHAR2)
514: IS

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

507: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
508: AND hoi_challan.org_information1 = g_tax_year
509: AND hoi_challan.org_information13 = g_quarter
510: AND fnd_date.canonical_to_date(hoi_challan.org_information2) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)
511: ORDER BY fnd_date.canonical_to_date(hoi_challan.org_information2);
512:
513: CURSOR csr_challan_bank(p_bank_code VARCHAR2)
514: IS
515: SELECT hoi_bank.org_information4 Bank

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

716: AND hou.business_group_id = g_bg_id
717: AND pep.person_id = hoi.org_information1
718: AND pep.business_group_id = hou.business_group_id
719: AND p_effective_date BETWEEN pep.effective_start_date AND pep.effective_end_date
720: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
721: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
722: AND p_effective_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
723:
724: CURSOR c_rep_address(p_person_id NUMBER)

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

717: AND pep.person_id = hoi.org_information1
718: AND pep.business_group_id = hou.business_group_id
719: AND p_effective_date BETWEEN pep.effective_start_date AND pep.effective_end_date
720: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
721: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
722: AND p_effective_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
723:
724: CURSOR c_rep_address(p_person_id NUMBER)
725: IS

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

1055: ,p_action_information5 => p_person_table(1).pan_ref_number
1056: ,p_action_information6 => p_person_table(1).full_name
1057: ,p_action_information7 => p_person_table(1).tax_rate
1058: ,p_action_information8 => p_person_table(1).position
1059: ,p_action_information9 => fnd_date.date_to_canonical(l_effective_start_date)
1060: ,p_action_information10 => fnd_date.date_to_canonical(l_effective_end_date)
1061: ,p_action_information_id => l_action_info_id
1062: ,p_object_version_number => l_ovn
1063: );

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

1056: ,p_action_information6 => p_person_table(1).full_name
1057: ,p_action_information7 => p_person_table(1).tax_rate
1058: ,p_action_information8 => p_person_table(1).position
1059: ,p_action_information9 => fnd_date.date_to_canonical(l_effective_start_date)
1060: ,p_action_information10 => fnd_date.date_to_canonical(l_effective_end_date)
1061: ,p_action_information_id => l_action_info_id
1062: ,p_object_version_number => l_ovn
1063: );
1064:

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

2512: AND ROWNUM =1;
2513:
2514: CURSOR c_termination_check(p_assignment_id NUMBER)
2515: IS
2516: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2517: FROM per_all_assignments_f asg
2518: ,per_periods_of_service pos
2519: WHERE asg.person_id = pos.person_id
2520: AND asg.assignment_id = p_assignment_id