APPS.PQH_FR_UTILITY dependencies on PQH_FR_STAT_SITUATIONS

Line 812: from pqh_fr_stat_situations_v sit , per_shared_types_vl sh

808: --
809: --
810: Cursor csr_situation_details IS
811: Select statutory_situation_id
812: from pqh_fr_stat_situations_v sit , per_shared_types_vl sh
813: where sh.shared_type_id = type_of_ps
814: and sh.system_type_cd = nvl(pqh_fr_utility.GET_BG_TYPE_OF_PS,sh.system_type_cd)
815: and sit.business_group_id = hr_general.get_business_group_id
816: and sit.default_flag = 'Y'

Line 1063: FROM pqh_fr_stat_situations sts,

1059: SELECT sts.situation_type,
1060: sts.sub_type,
1061: sts.remuneration_paid,
1062: sts.pay_share
1063: FROM pqh_fr_stat_situations sts,
1064: pqh_fr_emp_stat_situations ess
1065: WHERE ess.emp_stat_situation_id = p_emp_stat_situation_id
1066: AND ess.statutory_situation_id = sts.statutory_situation_id;
1067: l_sts_dtls csr_sts_dtls%ROWTYPE;