APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on HR_SOFT_CODING_KEYFLEX

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

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

Line 82: , HR_SOFT_CODING_KEYFLEX scl

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

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

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

Line 111: ,HR_SOFT_CODING_KEYFLEX sck

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