APPS.HRI_OLTP_VIEW_WRKFRC_ORGH dependencies on HRI_MDS_WRKFC_ORGH_C01_CT

Line 12: FROM hri_mds_wrkfc_orgh_c01_ct wrkfc

8: RETURN NUMBER IS
9:
10: CURSOR hdc_csr IS
11: SELECT NVL(SUM(wrkfc.headcount_end), 0)
12: FROM hri_mds_wrkfc_orgh_c01_ct wrkfc
13: WHERE wrkfc.sup_organztn_fk = p_sup_organization_id
14: AND wrkfc.time_month_snp_fk = to_number(to_char(p_effective_date, 'YYYYQMM'))
15: AND wrkfc.ptyp_wrktyp_fk = p_worker_type
16: AND wrkfc.sup_directs_only_flag = p_directs_only;

Line 38: FROM hri_mds_wrkfc_orgh_c01_ct wrkfc

34: RETURN NUMBER IS
35:
36: CURSOR fte_csr IS
37: SELECT NVL(SUM(wrkfc.fte_end), 0)
38: FROM hri_mds_wrkfc_orgh_c01_ct wrkfc
39: WHERE wrkfc.sup_organztn_fk = p_sup_organization_id
40: AND wrkfc.time_month_snp_fk = to_char(p_effective_date, 'YYYYQMM')
41: AND wrkfc.ptyp_wrktyp_fk = p_worker_type
42: AND wrkfc.sup_directs_only_flag = p_directs_only;

Line 64: FROM hri_mds_wrkfc_orgh_c01_ct wrkfc

60: RETURN NUMBER IS
61:
62: CURSOR pasg_cnt_csr IS
63: SELECT NVL(SUM(wrkfc.count_pasg_end), 0)
64: FROM hri_mds_wrkfc_orgh_c01_ct wrkfc
65: WHERE wrkfc.sup_organztn_fk = p_sup_organization_id
66: AND wrkfc.time_month_snp_fk = to_char(p_effective_date, 'YYYYQMM')
67: AND wrkfc.ptyp_wrktyp_fk = p_worker_type
68: AND wrkfc.sup_directs_only_flag = p_directs_only;

Line 90: FROM hri_mds_wrkfc_orgh_c01_ct wrkfc

86: RETURN NUMBER IS
87:
88: CURSOR asg_cnt_csr IS
89: SELECT NVL(SUM(wrkfc.count_asg_end), 0)
90: FROM hri_mds_wrkfc_orgh_c01_ct wrkfc
91: WHERE wrkfc.sup_organztn_fk = p_sup_organization_id
92: AND wrkfc.time_month_snp_fk = to_char(p_effective_date, 'YYYYQMM')
93: AND wrkfc.ptyp_wrktyp_fk = p_worker_type
94: AND wrkfc.sup_directs_only_flag = p_directs_only;