DBA Data[Home] [Help]

APPS.PAY_NEGBAL_PKG dependencies on PAY_STATE_RULES

Line 155: pay_state_rules SR,

151: sqlstr := 'SELECT distinct ASG.person_id
152: FROM per_assignments_f ASG,
153: hr_organization_units HOU,
154: pay_payrolls_f PPY,
155: pay_state_rules SR,
156: hr_organization_information HOI,
157: pay_us_asg_reporting puar,
158: pay_payroll_actions PPA
159: WHERE PPA.payroll_action_id = :payroll_action_id

Line 224: pay_state_rules sr,

220: sr.jurisdiction_code jurisdiction_code
221: FROM hr_organization_information hoi,
222: pay_payroll_actions ppa,
223: pay_assignment_actions paa,
224: pay_state_rules sr,
225: per_assignments_f asg,
226: pay_payroll_actions ppa_arch
227: WHERE ppa_arch.payroll_action_id = pactid
228: AND asg.person_id between stperson and endperson