DBA Data[Home] [Help]

APPS.HRI_OPL_SUP_WRKFC_ASG dependencies on HRI_CS_PRSNTYP_CT

Line 323: FROM hri_cs_prsntyp_ct prsn,

319: (SELECT prsn.wkth_wktyp_sk_fk,
320: prsn.wkth_lvl1_sk_fk,
321: prsn.wkth_lvl2_sk_fk,
322: prsn.wkth_wktyp_code
323: FROM hri_cs_prsntyp_ct prsn,
324: hri_mb_asgn_events_ct asgn
325: WHERE prsn.prsntyp_sk_pk = asgn.prsntyp_sk_fk
326: AND asgn.assignment_id = asg_dlt.assignment_id
327: AND ROWNUM < 2

Line 654: ,hri_cs_prsntyp_ct prsn

650: hri_eq_asg_sup_wrfc eq
651: ,hri_mb_asgn_events_ct evts
652: ,hri_cs_jobh_ct jobh
653: ,hri_cs_geo_lochr_ct geoh
654: ,hri_cs_prsntyp_ct prsn
655: ,hri_cs_job_job_role_ct rolj
656: ,hri_cs_suph suph
657: WHERE suph.sub_person_id = evts.supervisor_id
658: AND suph.sup_invalid_flag_code = 'N'

Line 798: ,hri_cs_prsntyp_ct prsn

794: hri_eq_asg_sup_wrfc eq
795: ,hri_mb_asgn_events_ct evts
796: ,hri_cs_jobh_ct jobh
797: ,hri_cs_geo_lochr_ct geoh
798: ,hri_cs_prsntyp_ct prsn
799: ,hri_cs_job_job_role_ct rolj
800: ,hri_cs_suph suph
801: WHERE suph.sub_person_id = evts.supervisor_id
802: AND suph.sup_invalid_flag_code = 'N'

Line 1147: ,hri_cs_prsntyp_ct prsn

1143: hri_mb_asgn_events_ct evts
1144: ,hri_cs_jobh_ct jobh
1145: ,hri_cs_geo_lochr_ct geoh
1146: ,hri_cs_suph suph
1147: ,hri_cs_prsntyp_ct prsn
1148: ,hri_cs_job_job_role_ct rolj
1149: ,hri_eq_asg_sup_wrfc eq
1150: WHERE suph.sub_person_id = evts.supervisor_id
1151: AND suph.sup_invalid_flag_code = 'N'

Line 1291: ,hri_cs_prsntyp_ct prsn

1287: hri_mb_asgn_events_ct evts
1288: ,hri_cs_jobh_ct jobh
1289: ,hri_cs_geo_lochr_ct geoh
1290: ,hri_cs_suph suph
1291: ,hri_cs_prsntyp_ct prsn
1292: ,hri_cs_job_job_role_ct rolj
1293: ,hri_eq_asg_sup_wrfc eq
1294: WHERE suph.sub_person_id = evts.supervisor_id
1295: AND suph.sup_invalid_flag_code = 'N'

Line 1687: ,hri_cs_prsntyp_ct prsn

1683: FROM
1684: hri_mb_asgn_events_ct evts
1685: ,hri_cs_jobh_ct jobh
1686: ,hri_cs_geo_lochr_ct geoh
1687: ,hri_cs_prsntyp_ct prsn
1688: ,hri_cs_job_job_role_ct rolj
1689: ,hri_cs_suph suph
1690: WHERE suph.sub_person_id = evts.supervisor_id
1691: AND suph.sup_invalid_flag_code = ''N''

Line 1817: ,hri_cs_prsntyp_ct prsn

1813: FROM
1814: hri_mb_asgn_events_ct evts
1815: ,hri_cs_jobh_ct jobh
1816: ,hri_cs_geo_lochr_ct geoh
1817: ,hri_cs_prsntyp_ct prsn
1818: ,hri_cs_job_job_role_ct rolj
1819: ,hri_cs_suph suph
1820: WHERE suph.sub_person_id = evts.supervisor_id
1821: AND suph.sup_invalid_flag_code = ''N''