APPS.PAY_KW_PIFSS dependencies on HR_SOFT_CODING_KEYFLEX

Line 61: SELECT /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'

57: FROM pay_payroll_actions ppa
58: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
59: --
60: CURSOR CSR_KW_PIFSS_BODY IS
61: SELECT /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
62: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')
63: ,'AMOUNT=P'
64: , pay_kw_pifss_report.get_amount_cont(
65: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id'),paa.assignment_action_id,pef.person_id , to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')

Line 96: ,hr_soft_coding_keyflex hscl

92: ,'TAX_UNIT_ID=C' , paa.tax_unit_id
93: FROM per_assignments_f asg
94: ,pay_assignment_actions paa
95: ,pay_payroll_actions ppa
96: ,hr_soft_coding_keyflex hscl
97: ,per_people_f pef
98: ,pay_payroll_actions ppa1
99: ,pay_legislation_rules leg
100: WHERE asg.assignment_id = paa.assignment_id

Line 120: SELECT /*+ INDEX(hscl,HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'

116: AND leg.rule_mode = hscl.id_flex_num
117: AND pef.nationality = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'LOCAL_NATIONALITY');
118: --
119: CURSOR CSR_KW_PIFSS_FOOTER IS
120: SELECT /*+ INDEX(hscl,HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
121: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')
122: ,'EMPLOYER_KEY=P'
123: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Key')
124: ,'DED_SSN=P'

Line 159: ,hr_soft_coding_keyflex hscl

155: ,'TAX_UNIT_ID=C' , paa.tax_unit_id
156: FROM per_assignments_f asg
157: ,pay_assignment_actions paa
158: ,pay_payroll_actions ppa
159: ,hr_soft_coding_keyflex hscl
160: ,per_people_f pef
161: ,pay_payroll_actions ppa1
162: ,pay_legislation_rules leg
163: WHERE asg.assignment_id = paa.assignment_id