APPS.PAY_NL_ANNUAL_SI_FILE dependencies on HR_SOFT_CODING_KEYFLEX

Line 245: SELECT segment30 from hr_soft_Coding_keyflex where soft_coding_keyflex_id = p_scl_id;

241: WHERE past.per_system_status = 'ACTIVE_ASSIGN'
242: AND asg.assignment_status_type_id = past.assignment_status_type_id and assignment_id = p_assignment_id);
243:
244: CURSOR get_si_special_indicator(p_scl_id NUMBER) IS
245: SELECT segment30 from hr_soft_Coding_keyflex where soft_coding_keyflex_id = p_scl_id;
246:
247: l_scl_id NUMBER;
248:
249:

Line 642: ,hr_soft_coding_keyflex scl_flx

638: pap.national_identifier
639: from
640: per_all_people_f pap
641: ,per_all_assignments_f paa
642: ,hr_soft_coding_keyflex scl_flx
643: where
644: pap.business_group_id =p_business_group_id
645: and pap.person_id = paa.person_id
646: and paa.person_id BETWEEN p_start_person_id AND p_end_person_id