APPS.PQH_FR_EMP_STAT_SITUATION_API dependencies on PQH_FR_EMP_STAT_SITUATIONS

Line 569: FROM pqh_fr_emp_stat_situations

565: l_object_version_number NUMBER(9);
566: l_orig_object_version_number NUMBER(9);
567: CURSOR csr_situation_approved(p_emp_stat_situation_id IN NUMBER) IS
568: SELECT NVL(approval_flag, 'N')
569: FROM pqh_fr_emp_stat_situations
570: WHERE emp_stat_situation_id = p_emp_stat_situation_id;
571: l_sit_approval varchar2(10) ;
572: l_proc varchar2(72) := g_package||'update_emp_stat_situation';
573: l_actual_start_date DATE;

Line 715: FROM pqh_fr_emp_stat_situations

711: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER) IS
712: l_proc varchar2(72) := g_package||'renew_emp_stat_situation';
713: CURSOR Csr_current_situation_dtls (p_emp_stat_situation_id IN NUMBER) IS
714: SELECT *
715: FROM pqh_fr_emp_stat_situations
716: WHERE emp_stat_situation_id = p_emp_stat_situation_id;
717: lr_currec csr_current_situation_dtls%ROWTYPE;
718: l_new_prov_end_date DATE;
719: l_upd_sit_ovn NUMBER(9);

Line 788: FROM pqh_fr_emp_stat_situations

784: l_new_sit_ovn NUMBER(9);
785: l_upd_sit_ovn NUMBER(9);
786: CURSOR Csr_current_situation_dtls (p_emp_stat_situation_id IN NUMBER) IS
787: SELECT *
788: FROM pqh_fr_emp_stat_situations
789: WHERE emp_stat_situation_id = p_emp_stat_situation_id;
790: lr_currec csr_current_situation_dtls%ROWTYPE;
791: CURSOR Csr_prov_end_date (p_emp_stat_situation_id IN NUMBER, p_person_id IN NUMBER, p_eff_date IN DATE) IS
792: SELECT max(NVL(actual_start_date,provisional_start_date))

Line 793: FROM pqh_fr_emp_stat_situations

789: WHERE emp_stat_situation_id = p_emp_stat_situation_id;
790: lr_currec csr_current_situation_dtls%ROWTYPE;
791: CURSOR Csr_prov_end_date (p_emp_stat_situation_id IN NUMBER, p_person_id IN NUMBER, p_eff_date IN DATE) IS
792: SELECT max(NVL(actual_start_date,provisional_start_date))
793: FROM pqh_fr_emp_stat_situations
794: WHERE emp_stat_situation_id <> p_emp_stat_situation_id
795: AND person_Id = p_person_id
796: AND p_eff_date BETWEEN provisional_start_date and provisional_end_date;
797: l_next_sit_end_dt DATE;