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

Line 200: FND_DATE.CANONICAL_TO_DATE(hoi.org_information1) and

196: AND hoi.organization_id = p_organization_id
197: AND hoi.org_information4 = p_si_provider_id
198: AND hoi.org_information3 IN('ZFW','ZW','WW','WAO','AMI')
199: AND p_nsi_process_date between
200: FND_DATE.CANONICAL_TO_DATE(hoi.org_information1) and
201: nvl(FND_DATE.CANONICAL_TO_DATE(hoi.org_information2),hr_general.end_of_time)
202: ORDER BY ORG_INFORMATION7,DECODE(hoi.org_information3,'ZFW',1,'ZW',2,'WW',3,'WAO',4,'AMI',5,6) ;
203: v_csr_get_sender_det csr_get_sender_det%ROWTYPE;
204: --

Line 201: nvl(FND_DATE.CANONICAL_TO_DATE(hoi.org_information2),hr_general.end_of_time)

197: AND hoi.org_information4 = p_si_provider_id
198: AND hoi.org_information3 IN('ZFW','ZW','WW','WAO','AMI')
199: AND p_nsi_process_date between
200: FND_DATE.CANONICAL_TO_DATE(hoi.org_information1) and
201: nvl(FND_DATE.CANONICAL_TO_DATE(hoi.org_information2),hr_general.end_of_time)
202: ORDER BY ORG_INFORMATION7,DECODE(hoi.org_information3,'ZFW',1,'ZW',2,'WW',3,'WAO',4,'AMI',5,6) ;
203: v_csr_get_sender_det csr_get_sender_det%ROWTYPE;
204: --
205: --

Line 478: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date

474: ,lp_last_nsi_process_date date,lp_nsi_process_date date) IS
475: SELECT
476: paa.person_id ,paa.assignment_id
477: ,paa.organization_id,paa.effective_start_date ,paa.effective_end_date
478: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
479: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
480: ,hr_general.start_of_time cad_eff_start_date
481: ,hr_general.end_of_time cad_eff_end_date
482: ,scl_flx.SEGMENT2 Employment_Type

Line 479: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date

475: SELECT
476: paa.person_id ,paa.assignment_id
477: ,paa.organization_id,paa.effective_start_date ,paa.effective_end_date
478: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
479: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
480: ,hr_general.start_of_time cad_eff_start_date
481: ,hr_general.end_of_time cad_eff_end_date
482: ,scl_flx.SEGMENT2 Employment_Type
483: ,scl_flx.SEGMENT3 Employment_SubType

Line 505: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)

501: AND paa.assignment_id = ee_si.assignment_id
502: AND ee_si.aei_information_category='NL_SII'
503: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
504: AND paa.effective_start_date
505: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
506: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
507: and paa.effective_start_date BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date
508: AND (lp_report_type = 'NL_GAK_NSI_ARCHIVE' ) /* Gak Asg Date Track Changes*/
509: UNION

Line 506: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)

502: AND ee_si.aei_information_category='NL_SII'
503: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
504: AND paa.effective_start_date
505: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
506: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
507: and paa.effective_start_date BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date
508: AND (lp_report_type = 'NL_GAK_NSI_ARCHIVE' ) /* Gak Asg Date Track Changes*/
509: UNION
510: SELECT

Line 513: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date

509: UNION
510: SELECT
511: paa.person_id,paa.assignment_id
512: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
513: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
514: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
515: ,hr_general.start_of_time cad_eff_start_date
516: ,hr_general.end_of_time cad_eff_end_date
517: ,scl_flx.SEGMENT2 Employment_Type

Line 514: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date

510: SELECT
511: paa.person_id,paa.assignment_id
512: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
513: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
514: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
515: ,hr_general.start_of_time cad_eff_start_date
516: ,hr_general.end_of_time cad_eff_end_date
517: ,scl_flx.SEGMENT2 Employment_Type
518: ,scl_flx.SEGMENT3 Employment_SubType

Line 540: AND FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)

536: AND paa.assignment_id = ee_si.assignment_id
537: AND ee_si.aei_information_category='NL_SII'
538: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
539: AND lp_nsi_process_date BETWEEN paa.effective_start_date AND paa.effective_end_date
540: AND FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
541: BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date /* NL_SII-Code Insurance EIT Date Track Changes*/
542: UNION
543: SELECT
544: paa.person_id,paa.assignment_id

Line 546: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date

542: UNION
543: SELECT
544: paa.person_id,paa.assignment_id
545: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
546: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
547: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
548: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
549: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
550: ,scl_flx.SEGMENT2 Employment_Type

Line 547: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date

543: SELECT
544: paa.person_id,paa.assignment_id
545: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
546: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
547: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
548: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
549: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
550: ,scl_flx.SEGMENT2 Employment_Type
551: ,scl_flx.SEGMENT3 Employment_SubType

Line 548: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date

544: paa.person_id,paa.assignment_id
545: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
546: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
547: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
548: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
549: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
550: ,scl_flx.SEGMENT2 Employment_Type
551: ,scl_flx.SEGMENT3 Employment_SubType
552: ,scl_flx.SEGMENT6 Work_Pattern

Line 549: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date

545: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
546: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
547: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
548: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
549: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
550: ,scl_flx.SEGMENT2 Employment_Type
551: ,scl_flx.SEGMENT3 Employment_SubType
552: ,scl_flx.SEGMENT6 Work_Pattern
553: ,paa.assignment_status_type_id

Line 574: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)

570: AND paa.assignment_id = ee_si.assignment_id
571: AND ee_si.aei_information_category='NL_SII'
572: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
573: AND paa.effective_start_date
574: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
575: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
576: AND paa.assignment_id = ee_cadans.assignment_id(+)
577: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
578: and paa.effective_start_date BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date

Line 575: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)

571: AND ee_si.aei_information_category='NL_SII'
572: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
573: AND paa.effective_start_date
574: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
575: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
576: AND paa.assignment_id = ee_cadans.assignment_id(+)
577: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
578: and paa.effective_start_date BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date
579: AND paa.effective_start_date

Line 580: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time)

576: AND paa.assignment_id = ee_cadans.assignment_id(+)
577: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
578: and paa.effective_start_date BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date
579: AND paa.effective_start_date
580: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time)
581: AND (lp_report_type = 'NL_CAD_NSI_ARCHIVE' OR lp_report_type='NL_CADZ_NSI_ARCHIVE' ) /* Cadans Asg Date Track Changes*/
582: UNION
583: SELECT
584: paa.person_id,paa.assignment_id

Line 586: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date

582: UNION
583: SELECT
584: paa.person_id,paa.assignment_id
585: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
586: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
587: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
588: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
589: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
590: ,scl_flx.SEGMENT2 Employment_Type

Line 587: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date

583: SELECT
584: paa.person_id,paa.assignment_id
585: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
586: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
587: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
588: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
589: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
590: ,scl_flx.SEGMENT2 Employment_Type
591: ,scl_flx.SEGMENT3 Employment_SubType

Line 588: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date

584: paa.person_id,paa.assignment_id
585: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
586: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
587: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
588: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
589: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
590: ,scl_flx.SEGMENT2 Employment_Type
591: ,scl_flx.SEGMENT3 Employment_SubType
592: ,scl_flx.SEGMENT6 Work_Pattern

Line 589: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date

585: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
586: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
587: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
588: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
589: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
590: ,scl_flx.SEGMENT2 Employment_Type
591: ,scl_flx.SEGMENT3 Employment_SubType
592: ,scl_flx.SEGMENT6 Work_Pattern
593: ,paa.assignment_status_type_id

Line 615: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)

611: AND paa.assignment_id = ee_si.assignment_id
612: AND ee_si.aei_information_category='NL_SII'
613: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
614: AND paa.effective_start_date
615: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
616: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
617: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
618: BETWEEN paa.effective_start_date AND paa.effective_end_date
619: AND paa.assignment_id = ee_cadans.assignment_id

Line 616: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)

612: AND ee_si.aei_information_category='NL_SII'
613: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
614: AND paa.effective_start_date
615: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
616: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
617: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
618: BETWEEN paa.effective_start_date AND paa.effective_end_date
619: AND paa.assignment_id = ee_cadans.assignment_id
620: AND ee_cadans.aei_information_category='NL_CADANS_INFO'

Line 617: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)

613: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
614: AND paa.effective_start_date
615: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
616: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
617: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
618: BETWEEN paa.effective_start_date AND paa.effective_end_date
619: AND paa.assignment_id = ee_cadans.assignment_id
620: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
621: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)

Line 621: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)

617: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
618: BETWEEN paa.effective_start_date AND paa.effective_end_date
619: AND paa.assignment_id = ee_cadans.assignment_id
620: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
621: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
622: BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date /* Cadans EIT Date Track Changes*/
623: order by 1,2,4,5;
624: csr_ee_asg_nsi csr_ee_asg_si_info%ROWTYPE;
625:

Line 822: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information1)

818: ,ee_gak.aei_information4 Weekly_4_Exp_SI_Days
819: FROM per_assignment_extra_info ee_gak
820: WHERE ee_gak.assignment_id = lp_assignment_id
821: AND ee_gak.aei_information_category='NL_GAK_INFO'
822: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information1)
823: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information2),hr_general.END_OF_TIME) ;
824: v_csr_ee_gak csr_ee_gak%ROWTYPE;
825:
826: --Select EE Cadans Info

Line 823: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information2),hr_general.END_OF_TIME) ;

819: FROM per_assignment_extra_info ee_gak
820: WHERE ee_gak.assignment_id = lp_assignment_id
821: AND ee_gak.aei_information_category='NL_GAK_INFO'
822: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information1)
823: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information2),hr_general.END_OF_TIME) ;
824: v_csr_ee_gak csr_ee_gak%ROWTYPE;
825:
826: --Select EE Cadans Info
827: CURSOR csr_ee_cadans (lp_person_id NUMBER

Line 839: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)

835: ,ee_cadans.aei_information7 risk_fund
836: FROM per_assignment_extra_info ee_cadans
837: WHERE ee_cadans.assignment_id = lp_assignment_id
838: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
839: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
840: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.END_OF_TIME) ;
841: v_csr_ee_cadans csr_ee_cadans%ROWTYPE;
842:
843: l_last_nsi_min_notify_date DATE;

Line 840: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.END_OF_TIME) ;

836: FROM per_assignment_extra_info ee_cadans
837: WHERE ee_cadans.assignment_id = lp_assignment_id
838: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
839: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
840: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.END_OF_TIME) ;
841: v_csr_ee_cadans csr_ee_cadans%ROWTYPE;
842:
843: l_last_nsi_min_notify_date DATE;
844: