DBA Data[Home] [Help]

APPS.PAY_PSD_BUS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 401: per_assignment_status_types where

397: paaf.business_group_id = p_business_group_id and
398: p_effective_date between paaf.effective_start_date and
399: paaf.effective_end_date and
400: paaf.assignment_status_type_id in (select assignment_status_type_id from
401: per_assignment_status_types where
402: per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN'))
403: and paaf.soft_coding_keyflex_id = hrsoft.soft_coding_keyflex_id and
404: hrsoft.segment3 in (l_civil_catg,l_lump_catg,l_f_lump_catg);
405:

Line 415: per_assignment_status_types where

411: paaf.business_group_id = p_business_group_id and
412: p_effective_date between paaf.effective_start_date and
413: paaf.effective_end_date and
414: paaf.assignment_status_type_id in (select assignment_status_type_id from
415: per_assignment_status_types where
416: per_system_status = 'TERM_ASSIGN')
417: and paaf.soft_coding_keyflex_id = hrsoft.soft_coding_keyflex_id and
418: hrsoft.segment3 = l_term_catg;
419: