APPS.PAY_FI_TAX_CARD_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 33: SELECT /*+ INDEX(scl, HR_SOFT_CODING_KEYFLEX_PK) */ 'EMPLOYERS_ID=P'

29: * Cursor to fetch Body record information *
30: ********************************************************/
31:
32: CURSOR CSR_FI_TAX_CARD IS
33: SELECT /*+ INDEX(scl, HR_SOFT_CODING_KEYFLEX_PK) */ 'EMPLOYERS_ID=P'
34: ,hoi2.org_information1 || '-'|| hoi5.org_information1
35: ,'EMPLOYEES_ID=P'
36: ,pap.national_identifier
37: ,'PREPAYMENT_YEAR=P'

Line 48: , HR_SOFT_CODING_KEYFLEX scl

44: FROM PAY_PAYROLL_ACTIONS ppa
45: , PER_ALL_PEOPLE_F pap
46: , PER_ALL_ASSIGNMENTS_F paa
47: , PAY_LEGISLATION_RULES plr
48: , HR_SOFT_CODING_KEYFLEX scl
49: , HR_ORGANIZATION_INFORMATION hoi1
50: , HR_ORGANIZATION_INFORMATION hoi2
51: , HR_ORGANIZATION_INFORMATION hoi3
52: , HR_ORGANIZATION_INFORMATION hoi4

Line 65: and (paa.assignment_id,pap.person_id ) in (SELECT /*+ INDEX(scl1, HR_SOFT_CODING_KEYFLEX_PK) */ min(paa.assignment_id),pap1.person_id

61: and scl.id_flex_num = plr.rule_mode
62: and scl.enabled_flag='Y'
63: and plr.legislation_code = 'FI'
64: and plr.rule_type = 'S'
65: and (paa.assignment_id,pap.person_id ) in (SELECT /*+ INDEX(scl1, HR_SOFT_CODING_KEYFLEX_PK) */ min(paa.assignment_id),pap1.person_id
66: FROM per_all_assignments_f paa
67: ,per_all_people_f pap1
68: ,HR_SOFT_CODING_KEYFLEX scl1
69: ,HR_ORGANIZATION_INFORMATION hoi6

Line 68: ,HR_SOFT_CODING_KEYFLEX scl1

64: and plr.rule_type = 'S'
65: and (paa.assignment_id,pap.person_id ) in (SELECT /*+ INDEX(scl1, HR_SOFT_CODING_KEYFLEX_PK) */ min(paa.assignment_id),pap1.person_id
66: FROM per_all_assignments_f paa
67: ,per_all_people_f pap1
68: ,HR_SOFT_CODING_KEYFLEX scl1
69: ,HR_ORGANIZATION_INFORMATION hoi6
70: WHERE paa.person_id = pap1.person_id
71: and ppa.BUSINESS_GROUP_ID = pap1.BUSINESS_GROUP_ID
72: and ppa.effective_date BETWEEN pap1.effective_start_date and pap1.effective_end_date