DBA Data[Home] [Help]

APPS.PAY_PPD_BUS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 778: per_assignment_status_types where

774: paaf.business_group_id = p_business_group_id and
775: p_effective_date between paaf.effective_start_date and
776: paaf.effective_end_date and
777: paaf.assignment_status_type_id in (select assignment_status_type_id from
778: per_assignment_status_types where
779: per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN'))
780: and paaf.soft_coding_keyflex_id = hrsoft.soft_coding_keyflex_id and
781: hrsoft.segment3 in (l_civil_catg,l_lump_catg,l_f_lump_catg);
782:

Line 792: per_assignment_status_types where

788: paaf.business_group_id = p_business_group_id and
789: p_effective_date between paaf.effective_start_date and
790: paaf.effective_end_date and
791: paaf.assignment_status_type_id in (select assignment_status_type_id from
792: per_assignment_status_types where
793: per_system_status = 'TERM_ASSIGN')
794: and paaf.soft_coding_keyflex_id = hrsoft.soft_coding_keyflex_id;
795: -- and hrsoft.segment3 = l_term_catg;
796: