APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_ASG_REPORTING

Line 4416: from pay_us_asg_reporting puar

4412:
4413: cursor c_get_jd (cp_assignment_id number
4414: ,cp_tax_unit_id number) is
4415: select substr(puar.jurisdiction_code,1,2)||'-000-0000'
4416: from pay_us_asg_reporting puar
4417: where puar.assignment_id = cp_assignment_id
4418: and puar.tax_unit_id = cp_tax_unit_id
4419: union
4420: select substr(puar.jurisdiction_code,1,6)||'-0000'

Line 4421: from pay_us_asg_reporting puar

4417: where puar.assignment_id = cp_assignment_id
4418: and puar.tax_unit_id = cp_tax_unit_id
4419: union
4420: select substr(puar.jurisdiction_code,1,6)||'-0000'
4421: from pay_us_asg_reporting puar
4422: where puar.assignment_id = cp_assignment_id
4423: and puar.tax_unit_id = cp_tax_unit_id
4424: and length(puar.jurisdiction_code) <> 8
4425: union

Line 4427: from pay_us_asg_reporting puar

4423: and puar.tax_unit_id = cp_tax_unit_id
4424: and length(puar.jurisdiction_code) <> 8
4425: union
4426: select puar.jurisdiction_code
4427: from pay_us_asg_reporting puar
4428: where puar.assignment_id = cp_assignment_id
4429: and puar.tax_unit_id = cp_tax_unit_id;
4430:
4431: ln_index NUMBER ;