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

Line 711: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);

707: END IF;
708:
709: pay_in_utils.set_location(g_debug,l_procedure, 20);
710:
711: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
712: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
713:
714: l_ovn := 1;
715:

Line 712: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

708:
709: pay_in_utils.set_location(g_debug,l_procedure, 20);
710:
711: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
712: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
713:
714: l_ovn := 1;
715:
716: pay_action_information_api.create_action_information

Line 1446: SELECT fnd_date.date_to_canonical(pap.date_of_birth) dob

1442: AND paa.effective_end_date;
1443: --
1444: CURSOR csr_person_details (p_person_id IN NUMBER)
1445: IS
1446: SELECT fnd_date.date_to_canonical(pap.date_of_birth) dob
1447: ,pap.per_information8 pf_number
1448: ,pap.per_information9 esi_number
1449: ,pap.per_information4 pan
1450: ,pap.per_information10 superannuation_number

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

3126: ,per_people_f peap
3127: WHERE hoi.ORGANIZATION_ID=p_pf_org_id
3128: AND hoi.ORG_INFORMATION_CONTEXT = DECODE (p_context,'PF','PER_IN_PF_REP_DF','ESI','PER_IN_ESI_REP_DF')
3129: AND peap.person_id=hoi.ORG_INFORMATION1
3130: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
3131: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'));
3132:
3133: -- Cursor to find ESI Rep's Address
3134: CURSOR c_rep_adr(p_person_id NUMBER

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

3127: WHERE hoi.ORGANIZATION_ID=p_pf_org_id
3128: AND hoi.ORG_INFORMATION_CONTEXT = DECODE (p_context,'PF','PER_IN_PF_REP_DF','ESI','PER_IN_ESI_REP_DF')
3129: AND peap.person_id=hoi.ORG_INFORMATION1
3130: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
3131: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'));
3132:
3133: -- Cursor to find ESI Rep's Address
3134: CURSOR c_rep_adr(p_person_id NUMBER
3135: ,p_effective_date DATE)

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

3812: ,per_people_f peap
3813: WHERE hoi.organization_id = p_pf_org_id
3814: AND hoi.org_information_context = 'PER_IN_PROF_TAX_REP_DF'
3815: AND peap.person_id = hoi.org_information1
3816: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
3817: AND NVL(fnd_date.canonical_to_date(hoi.org_information3)
3818: , TO_DATE('31-12-4712', 'DD-MM-YYYY'));
3819:
3820: --Cursor to find the Position of PT Rep

Line 3817: AND NVL(fnd_date.canonical_to_date(hoi.org_information3)

3813: WHERE hoi.organization_id = p_pf_org_id
3814: AND hoi.org_information_context = 'PER_IN_PROF_TAX_REP_DF'
3815: AND peap.person_id = hoi.org_information1
3816: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
3817: AND NVL(fnd_date.canonical_to_date(hoi.org_information3)
3818: , TO_DATE('31-12-4712', 'DD-MM-YYYY'));
3819:
3820: --Cursor to find the Position of PT Rep
3821: CURSOR c_rep_pos(p_person_id NUMBER