DBA Data[Home] [Help]

APPS.PQP_US_SRS_EXTRACTS dependencies on HR_SOFT_CODING_KEYFLEX

Line 472: From hr_soft_coding_keyflex sft,

468: Cursor c_tax_id ( c_assignment_id In per_all_assignments_f.assignment_id%Type
469: ,c_effective_date In Date) Is
470: Select to_number(sft.segment1),
471: asg.business_group_id
472: From hr_soft_coding_keyflex sft,
473: per_assignments_f asg
474: Where sft.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
475: And asg.assignment_id = c_assignment_id
476: And c_effective_date between asg.effective_start_date