APPS.PAY_SE_FORA dependencies on HR_SOFT_CODING_KEYFLEX

Line 325: hr_soft_coding_keyflex hsck

321: hsck.segment2 local_unit_id
322: FROM
323: per_all_assignments_f paaf,
324: per_jobs pj , --new
325: hr_soft_coding_keyflex hsck
326: WHERE assignment_id=csr_v_assignment_id --21197 --21257 --21233
327: AND csr_v_start_date <=paaf.EFFECTIVE_END_DATE AND
328: csr_v_end_date >=paaf.EFFECTIVE_START_DATE
329: AND primary_flag='Y'

Line 410: hr_soft_coding_keyflex hsck

406: IS
407: SELECT DISTINCT papf.person_id ,paaf.assignment_id
408: FROM per_all_assignments_f paaf,
409: per_all_people_f papf,
410: hr_soft_coding_keyflex hsck
411: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
412: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
413: AND papf.person_id=paaf.person_id
414: AND paaf.primary_flag='Y'

Line 506: hr_soft_coding_keyflex hsck

502: CURSOR csr_check_local_unit(csr_v_assignment_id NUMBER, csr_v_start_date DATE)
503: IS
504: SELECT hsck.segment2 FROM
505: per_all_assignments_f paaf,
506: hr_soft_coding_keyflex hsck
507: WHERE
508: paaf.assignment_id=csr_v_assignment_id
509: AND paaf.effective_start_date=csr_v_start_date
510: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id;

Line 516: hr_soft_coding_keyflex hsck

512: CURSOR csr_next_local_unit(csr_v_assignment_id NUMBER, csr_v_start_date DATE)
513: IS
514: SELECT hsck.segment2 FROM
515: per_all_assignments_f paaf,
516: hr_soft_coding_keyflex hsck
517: WHERE
518: paaf.assignment_id=csr_v_assignment_id
519: AND paaf.effective_start_date=
520: (SELECT min(effective_start_date)