APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on FND_DATE

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

777: END IF;
778:
779: pay_in_utils.set_location(g_debug,l_procedure, 20);
780:
781: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
782: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
783:
784: l_ovn := 1;
785:

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

778:
779: pay_in_utils.set_location(g_debug,l_procedure, 20);
780:
781: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
782: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
783:
784: l_ovn := 1;
785:
786: pay_action_information_api.create_action_information

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

1570: AND paa.effective_end_date;
1571: --
1572: CURSOR csr_person_details (p_person_id IN NUMBER)
1573: IS
1574: SELECT fnd_date.date_to_canonical(pap.date_of_birth) dob
1575: ,pap.per_information8 pf_number
1576: ,pap.per_information9 esi_number
1577: ,pap.per_information4 pan
1578: ,pap.per_information10 superannuation_number

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

3338: ,per_people_f peap
3339: WHERE hoi.ORGANIZATION_ID=p_pf_org_id
3340: AND hoi.ORG_INFORMATION_CONTEXT = DECODE (p_context,'PF','PER_IN_PF_REP_DF','ESI','PER_IN_ESI_REP_DF')
3341: AND peap.person_id=hoi.ORG_INFORMATION1
3342: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
3343: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'));
3344:
3345: -- Cursor to find ESI Rep's Address
3346: CURSOR c_rep_adr(p_person_id NUMBER

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

3339: WHERE hoi.ORGANIZATION_ID=p_pf_org_id
3340: AND hoi.ORG_INFORMATION_CONTEXT = DECODE (p_context,'PF','PER_IN_PF_REP_DF','ESI','PER_IN_ESI_REP_DF')
3341: AND peap.person_id=hoi.ORG_INFORMATION1
3342: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
3343: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'));
3344:
3345: -- Cursor to find ESI Rep's Address
3346: CURSOR c_rep_adr(p_person_id NUMBER
3347: ,p_effective_date DATE)

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

4032: ,per_people_f peap
4033: WHERE hoi.organization_id = p_pf_org_id
4034: AND hoi.org_information_context = 'PER_IN_PROF_TAX_REP_DF'
4035: AND peap.person_id = hoi.org_information1
4036: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
4037: AND NVL(fnd_date.canonical_to_date(hoi.org_information3)
4038: , TO_DATE('31-12-4712', 'DD-MM-YYYY'));
4039:
4040: --Cursor to find the Position of PT Rep

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

4033: WHERE hoi.organization_id = p_pf_org_id
4034: AND hoi.org_information_context = 'PER_IN_PROF_TAX_REP_DF'
4035: AND peap.person_id = hoi.org_information1
4036: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
4037: AND NVL(fnd_date.canonical_to_date(hoi.org_information3)
4038: , TO_DATE('31-12-4712', 'DD-MM-YYYY'));
4039:
4040: --Cursor to find the Position of PT Rep
4041: CURSOR c_rep_pos(p_person_id NUMBER