DBA Data[Home] [Help]

APPS.PER_US_VETC_TAP dependencies on PAY_STATE_RULES

Line 164: pay_state_rules psr1 ,

160: hr_tax_units_v htuv ,
161: hr_establishments_v est ,
162: hr_organization_units hou1 ,
163: hr_organization_units hou2 ,
164: pay_state_rules psr1 ,
165: pay_state_rules psr2
166: WHERE htuv.tax_unit_id (+) = hou1.organization_id
167: AND hou1.organization_id =
168: pay_magtape_generic.get_parameter_value('TRANSFER_TAX_UNIT_ID')

Line 165: pay_state_rules psr2

161: hr_establishments_v est ,
162: hr_organization_units hou1 ,
163: hr_organization_units hou2 ,
164: pay_state_rules psr1 ,
165: pay_state_rules psr2
166: WHERE htuv.tax_unit_id (+) = hou1.organization_id
167: AND hou1.organization_id =
168: pay_magtape_generic.get_parameter_value('TRANSFER_TAX_UNIT_ID')
169: AND cloc.location_id(+) = htuv.location_id

Line 434: pay_state_rules psr,

430: count(ass.assignment_id)
431: FROM per_assignments_f ass,
432: hr_establishments_v hev,
433: hr_locations hl,
434: pay_state_rules psr,
435: hr_organization_information hoi1,
436: hr_soft_coding_keyflex scf,
437: per_jobs job
438: WHERE job.job_information_category = 'US'