APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 74: CURSOR CSR_SE_BODY is select /*+ INDEX(scl, HR_SOFT_CODING_KEYFLEX_PK) */ 'ORG_NUM=P', RPAD(hoi2.org_information2,12),

70: AND hoi4.org_information1='PHONE'
71: AND ou.Location_id = HL.Location_id (+) ;
72:
73:
74: CURSOR CSR_SE_BODY is select /*+ INDEX(scl, HR_SOFT_CODING_KEYFLEX_PK) */ 'ORG_NUM=P', RPAD(hoi2.org_information2,12),
75: 'PERSON_NUM=P', RPAD((TO_CHAR(pap.DATE_OF_BIRTH,'CC')-2)||REPLACE(PAP.NATIONAL_IDENTIFIER,'-',''),12)
76: FROM HR_ORGANIZATION_INFORMATION hoi1
77: , HR_ORGANIZATION_INFORMATION hoi2
78: , HR_ORGANIZATION_INFORMATION hoi3

Line 81: , HR_SOFT_CODING_KEYFLEX scl

77: , HR_ORGANIZATION_INFORMATION hoi2
78: , HR_ORGANIZATION_INFORMATION hoi3
79: , HR_ORGANIZATION_INFORMATION hoi4
80: , PAY_LEGISLATION_RULES plr
81: , HR_SOFT_CODING_KEYFLEX scl
82: , PER_ALL_PEOPLE_F pap
83: , PER_ALL_ASSIGNMENTS_F paa
84: , PAY_PAYROLL_ACTIONS ppa
85: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 106: ( SELECT /*+ INDEX(sck, HR_SOFT_CODING_KEYFLEX_PK) */ min(paaf.assignment_id),sck.segment2

102: and ppa.effective_date BETWEEN paa.effective_start_date and paa.effective_end_date
103: and ppa.effective_date BETWEEN pap.effective_start_date and pap.effective_end_date
104: and (paa.assignment_id,scl.segment2)
105: in
106: ( SELECT /*+ INDEX(sck, HR_SOFT_CODING_KEYFLEX_PK) */ min(paaf.assignment_id),sck.segment2
107: FROM
108: per_all_people_f papf
109: ,per_all_assignments_f paaf
110: ,HR_SOFT_CODING_KEYFLEX sck

Line 110: ,HR_SOFT_CODING_KEYFLEX sck

106: ( SELECT /*+ INDEX(sck, HR_SOFT_CODING_KEYFLEX_PK) */ min(paaf.assignment_id),sck.segment2
107: FROM
108: per_all_people_f papf
109: ,per_all_assignments_f paaf
110: ,HR_SOFT_CODING_KEYFLEX sck
111: ,HR_ORGANIZATION_INFORMATION hroi
112: WHERE paaf.person_id = papf.person_id
113: and paaf.BUSINESS_GROUP_ID = ppa.BUSINESS_GROUP_ID
114: and ppa.effective_date BETWEEN paaf.effective_start_date and paaf.effective_end_date