DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on HR_SOFT_CODING_KEYFLEX

Line 85: -- hr_soft_coding_keyflex hsk,

81: pay_payroll_actions pa1,
82: pay_pre_payments ppp,
83: pay_org_payment_methods_f OPM,
84: per_all_people_f pap,
85: -- hr_soft_coding_keyflex hsk,
86: pay_payment_types ppt
87:
88: WHERE pa1.payroll_action_id = p_payroll_action_id
89: AND pa2.payroll_id = p_payroll_id

Line 134: and ( p_le_id is null or exists ( select 1 from hr_soft_coding_keyflex hsk

130: AND act2.payroll_action_id = appa.payroll_action_id
131: -- AND appa.action_type = 'X'
132: AND appa.action_type = 'M'
133: AND appa.report_type = 'NO_PP')
134: and ( p_le_id is null or exists ( select 1 from hr_soft_coding_keyflex hsk
135: where hsk.SOFT_CODING_KEYFLEX_ID = asg.SOFT_CODING_KEYFLEX_ID
136: and hsk.enabled_flag = 'Y'
137: and hsk.segment2 in (
138: select hoi2.org_information1