DBA Data[Home] [Help]

APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_US_STATES

Line 345: pay_us_states PUS,

341: (PA.effective_date, AA.assignment_id)),
342: 'TRANSFER_SCHOOL_DISTRICT=P',substr(PMV.jurisdiction_code,4,5),
343: 'JURISDICTION_CODE=C', PMV.jurisdiction_code
344: FROM
345: pay_us_states PUS,
346: pay_us_arch_mag_county_sd_v PMV,
347: pay_payroll_actions PA,
348: pay_assignment_actions AA
349:

Line 370: pay_us_states PUS,

366: (PA.effective_date, AA.assignment_id)),
367: 'TRANSFER_SCHOOL_DISTRICT=P', substr(PMC.jurisdiction_code,4,5),
368: 'JURISDICTION_CODE=C', PMC.jurisdiction_code
369: FROM
370: pay_us_states PUS,
371: pay_us_arch_mag_city_sd_v PMC,
372: pay_assignment_actions AA,
373: pay_payroll_actions PA
374: WHERE

Line 396: pay_us_states PUS,

392: (PA.effective_date, AA.assignment_id)),
393: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
394: 'JURISDICTION_CODE=C', PSV.jurisdiction_code
395: FROM
396: pay_us_states PUS,
397: pay_us_arch_mag_state_v PSV,
398: pay_assignment_actions AA,
399: pay_payroll_actions PA
400: WHERE