APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_ASG_REPORTING

Line 5362: from pay_us_asg_reporting puar

5358:
5359: cursor c_get_jd (cp_assignment_id number
5360: ,cp_tax_unit_id number) is
5361: select substr(puar.jurisdiction_code,1,2)||'-000-0000'
5362: from pay_us_asg_reporting puar
5363: where puar.assignment_id = cp_assignment_id
5364: and puar.tax_unit_id = cp_tax_unit_id
5365: union
5366: select substr(puar.jurisdiction_code,1,6)||'-0000'

Line 5367: from pay_us_asg_reporting puar

5363: where puar.assignment_id = cp_assignment_id
5364: and puar.tax_unit_id = cp_tax_unit_id
5365: union
5366: select substr(puar.jurisdiction_code,1,6)||'-0000'
5367: from pay_us_asg_reporting puar
5368: where puar.assignment_id = cp_assignment_id
5369: and puar.tax_unit_id = cp_tax_unit_id
5370: and length(puar.jurisdiction_code) <> 8
5371: union

Line 5373: from pay_us_asg_reporting puar

5369: and puar.tax_unit_id = cp_tax_unit_id
5370: and length(puar.jurisdiction_code) <> 8
5371: union
5372: select puar.jurisdiction_code
5373: from pay_us_asg_reporting puar
5374: where puar.assignment_id = cp_assignment_id
5375: and puar.tax_unit_id = cp_tax_unit_id;
5376:
5377: ln_index NUMBER ;