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

Line 391: ,p_action_information6 => fnd_date.date_to_canonical(l_hire_date)

387: ,p_action_information2 => g_arc_ref_no
388: ,p_action_information3 => g_month||g_year
389: ,p_action_information4 => l_pf_no
390: ,p_action_information5 => l_nssn
391: ,p_action_information6 => fnd_date.date_to_canonical(l_hire_date)
392: ,p_action_information7 => l_emp_type
393: ,p_action_information8 => fnd_date.date_to_canonical(l_term_date)
394: ,p_action_information9 => l_report
395: ,p_action_information10 => l_efile

Line 393: ,p_action_information8 => fnd_date.date_to_canonical(l_term_date)

389: ,p_action_information4 => l_pf_no
390: ,p_action_information5 => l_nssn
391: ,p_action_information6 => fnd_date.date_to_canonical(l_hire_date)
392: ,p_action_information7 => l_emp_type
393: ,p_action_information8 => fnd_date.date_to_canonical(l_term_date)
394: ,p_action_information9 => l_report
395: ,p_action_information10 => l_efile
396: ,p_action_information11 => l_eps
397: ,p_action_information12 => p_pf_org

Line 747: AND g_end_date BETWEEN fnd_date.canonical_to_date(org_information2)

743: org_information1 --Representative
744: FROM hr_organization_information hr_pf_org
745: WHERE org_information_context = 'PER_IN_PF_REP_DF'
746: AND hr_pf_org.organization_id = p_pf_org
747: AND g_end_date BETWEEN fnd_date.canonical_to_date(org_information2)
748: AND NVL(fnd_date.canonical_to_date(org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'));
749:
750: CURSOR csr_pos(p_person_id VARCHAR2)
751: IS

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

744: FROM hr_organization_information hr_pf_org
745: WHERE org_information_context = 'PER_IN_PF_REP_DF'
746: AND hr_pf_org.organization_id = p_pf_org
747: AND g_end_date BETWEEN fnd_date.canonical_to_date(org_information2)
748: AND NVL(fnd_date.canonical_to_date(org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'));
749:
750: CURSOR csr_pos(p_person_id VARCHAR2)
751: IS
752: SELECT nvl(pos.name,job.name) name

Line 959: ,fnd_date.canonical_to_date(hoi_challan.org_information6) Cheque_DD_Date

955: CURSOR csr_challans
956: IS
957: SELECT hoi_challan.org_information4 Payment_Type
958: ,hoi_challan.org_information5 Cheque_DD_No
959: ,fnd_date.canonical_to_date(hoi_challan.org_information6) Cheque_DD_Date
960: ,hoi_challan.org_information7 Bank_Code
961: ,hoi_challan.org_information8 Branch_Code
962: ,hoi_challan.org_information11 Dep_Bank_Code
963: ,hoi_challan.org_information9 Dep_Branch_Code

Line 974: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date

970:
971: CURSOR csr_challans_info
972: IS
973: SELECT hoi_challan.org_information11 Paid_Under_Protest
974: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
975: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
976: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))

Line 1186: ,p_action_information5 => fnd_date.date_to_canonical(l_Cheque_DD_Date)

1182: ,p_action_information1 => p_business_number
1183: ,p_action_information2 => l_Payment_Type
1184: ,p_action_information3 => p_pf_org
1185: ,p_action_information4 => l_Cheque_DD_No
1186: ,p_action_information5 => fnd_date.date_to_canonical(l_Cheque_DD_Date)
1187: ,p_action_information6 => fnd_date.date_to_canonical(l_Cheque_DD_Dep_Date)
1188: ,p_action_information7 => fnd_number.number_to_canonical(l_Amount)
1189: ,p_action_information8 => l_Challan_Ref
1190: ,p_action_information9 => l_Bank_Code

Line 1187: ,p_action_information6 => fnd_date.date_to_canonical(l_Cheque_DD_Dep_Date)

1183: ,p_action_information2 => l_Payment_Type
1184: ,p_action_information3 => p_pf_org
1185: ,p_action_information4 => l_Cheque_DD_No
1186: ,p_action_information5 => fnd_date.date_to_canonical(l_Cheque_DD_Date)
1187: ,p_action_information6 => fnd_date.date_to_canonical(l_Cheque_DD_Dep_Date)
1188: ,p_action_information7 => fnd_number.number_to_canonical(l_Amount)
1189: ,p_action_information8 => l_Challan_Ref
1190: ,p_action_information9 => l_Bank_Code
1191: ,p_action_information11 => l_Branch_Code

Line 1475: AND TO_CHAR(fnd_date.canonical_to_date(pai.action_information8),'Month-YYYY') = TO_CHAR (g_start_date,'Month-YYYY')

1471: AND hoi.org_information_context = 'PER_IN_COMPANY_RECEP_MAP'
1472: AND hoi.org_information3 = p_business_no
1473: AND hoi.org_information1 = g_challan_year
1474: AND hoi.org_information2 = g_challan_mth
1475: AND TO_CHAR(fnd_date.canonical_to_date(pai.action_information8),'Month-YYYY') = TO_CHAR (g_start_date,'Month-YYYY')
1476: );
1477:
1478:
1479: /*Cursor to get the Assignments that needs to be archived for