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 395: ,p_action_information6 => fnd_date.date_to_canonical(l_hire_date)

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

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

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

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

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

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

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

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

959: CURSOR csr_challans
960: IS
961: SELECT hoi_challan.org_information4 Payment_Type
962: ,hoi_challan.org_information5 Cheque_DD_No
963: ,fnd_date.canonical_to_date(hoi_challan.org_information6) Cheque_DD_Date
964: ,hoi_challan.org_information7 Bank_Code
965: ,hoi_challan.org_information8 Branch_Code
966: ,hoi_challan.org_information11 Dep_Bank_Code
967: ,hoi_challan.org_information9 Dep_Branch_Code

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

974:
975: CURSOR csr_challans_info
976: IS
977: SELECT hoi_challan.org_information11 Paid_Under_Protest
978: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
979: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))

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

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

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

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

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

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