APPS.PAY_GB_EOY_MAGTAPE dependencies on HR_SOFT_CODING_KEYFLEX

Line 792: flex HR_SOFT_CODING_KEYFLEX_PK,

788: p_tax_ref VARCHAR2) IS
789: select count(distinct master.assignment_id) from
790: ( SELECT /*+ ORDERED INDEX (asg PER_ASSIGNMENTS_F_N12,
791: ppf PAY_PAYROLLS_F_PK,
792: flex HR_SOFT_CODING_KEYFLEX_PK,
793: org HR_ORGANIZATION_INFORMATIO_FK1)
794: USE_NL(asg,ppf,flex,org) */
795: distinct asg.assignment_id, asg.effective_start_date, asg.effective_end_date
796: FROM per_all_assignments_f asg,

Line 798: hr_soft_coding_keyflex flex,

794: USE_NL(asg,ppf,flex,org) */
795: distinct asg.assignment_id, asg.effective_start_date, asg.effective_end_date
796: FROM per_all_assignments_f asg,
797: pay_all_payrolls_f ppf,
798: hr_soft_coding_keyflex flex,
799: hr_organization_information org
800: WHERE asg.person_id = p_person_id
801: AND asg.effective_end_date >= p_min_start_year_date
802: AND asg.effective_start_date <= p_max_end_year_date

Line 820: flex HR_SOFT_CODING_KEYFLEX_PK,

816: = substr(ltrim(substr(org_information1,4,11),'/') ,1,10)
817: ) master,
818: ( SELECT /*+ ORDERED INDEX (asg PER_ASSIGNMENTS_F_N12,
819: ppf PAY_PAYROLLS_F_PK,
820: flex HR_SOFT_CODING_KEYFLEX_PK,
821: org HR_ORGANIZATION_INFORMATIO_FK1)
822: USE_NL(asg,ppf,flex,org) */
823: distinct asg.assignment_id, asg.effective_start_date, asg.effective_end_date
824: FROM per_all_assignments_f asg,

Line 826: hr_soft_coding_keyflex flex,

822: USE_NL(asg,ppf,flex,org) */
823: distinct asg.assignment_id, asg.effective_start_date, asg.effective_end_date
824: FROM per_all_assignments_f asg,
825: pay_all_payrolls_f ppf,
826: hr_soft_coding_keyflex flex,
827: hr_organization_information org
828: WHERE asg.person_id = p_person_id
829: AND asg.effective_end_date >= p_min_start_year_date
830: AND asg.effective_start_date <= p_max_end_year_date