APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_STATE_RULES

Line 493: from pay_state_rules SR

489: /* Get the jurisdiction_code for the specified state code. */
490:
491: cursor csr_jurisdiction_code is
492: select SR.jurisdiction_code
493: from pay_state_rules SR
494: where SR.state_code = p_state;
495:
496: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
497:

Line 496: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;

492: select SR.jurisdiction_code
493: from pay_state_rules SR
494: where SR.state_code = p_state;
495:
496: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
497:
498: begin
499:
500: open csr_jurisdiction_code;

Line 783: pay_state_rules SR

779: and ASG.assignment_type = 'E'
780: and ASG.business_group_id = ppa.business_group_id -- 5152728
781: and exists (select '1'
782: from pay_us_asg_reporting puar,
783: pay_state_rules SR
784: where SR.state_code = l_state
785: and substr(SR.jurisdiction_code ,1,2) =
786: substr(puar.jurisdiction_code,1,2)
787: and ASG.assignment_id = puar.assignment_id

Line 825: pay_state_rules SR

821: and ASG.assignment_type = 'E'
822: and ASG.business_group_id = ppa.business_group_id -- 5152728
823: and exists (select '1'
824: from pay_us_asg_reporting puar,
825: pay_state_rules SR
826: where SR.state_code = l_state
827: and substr(SR.jurisdiction_code ,1,2) =
828: substr(puar.jurisdiction_code,1,2)
829: and ASG.assignment_id = puar.assignment_id

Line 860: pay_state_rules SR

856: and ASG.assignment_type = 'E'
857: and ASG.business_group_id = ppa.business_group_id -- 5152728
858: and exists (select '1'
859: from pay_us_asg_reporting puar,
860: pay_state_rules SR
861: where SR.state_code = l_state
862: and substr(SR.jurisdiction_code ,1,2) =
863: substr(puar.jurisdiction_code,1,2)
864: and ASG.assignment_id = puar.assignment_id

Line 902: pay_state_rules SR

898: and ASG.assignment_type = 'E'
899: and ASG.business_group_id = ppa.business_group_id -- 5152728
900: and exists (select '1'
901: from pay_us_asg_reporting puar,
902: pay_state_rules SR
903: where SR.state_code = l_state
904: and substr(SR.jurisdiction_code ,1,2) =
905: substr(puar.jurisdiction_code,1,2)
906: and ASG.assignment_id = puar.assignment_id

Line 939: pay_state_rules SR

935: and ASG.person_id between stperson and endperson
936: and ASG.assignment_type = 'E'
937: and exists (select '1'
938: from pay_us_asg_reporting puar,
939: pay_state_rules SR
940: where SR.state_code = l_state
941: and substr(SR.jurisdiction_code ,1,2) =
942: substr(puar.jurisdiction_code,1,2)
943: and ASG.assignment_id = puar.assignment_id

Line 980: pay_state_rules SR

976: and ppr.person_id = ASG.person_id
977: and ASG.assignment_type = 'E'
978: and exists (select '1'
979: from pay_us_asg_reporting puar,
980: pay_state_rules SR
981: where SR.state_code = l_state
982: and substr(SR.jurisdiction_code ,1,2) =
983: substr(puar.jurisdiction_code,1,2)
984: and ASG.assignment_id = puar.assignment_id

Line 1018: pay_state_rules SR

1014: AND ASG.person_id between stperson and endperson
1015: and ASG.assignment_type = 'E'
1016: AND EXISTS (select 'x'
1017: from pay_us_asg_reporting puar,
1018: pay_state_rules SR
1019: where substr(SR.jurisdiction_code ,1,2) =
1020: substr(puar.jurisdiction_code,1,2)
1021: and ASG.assignment_id = puar.assignment_id
1022: and puar.tax_unit_id = hoi_pr.organization_id

Line 1069: pay_state_rules SR

1065: and ppr.person_id = ASG.person_id
1066: and ASG.assignment_type = 'E'
1067: AND EXISTS (select 'x'
1068: from pay_us_asg_reporting puar,
1069: pay_state_rules SR
1070: where substr(SR.jurisdiction_code ,1,2) =
1071: substr(puar.jurisdiction_code,1,2)
1072: and ASG.assignment_id = puar.assignment_id
1073: and puar.tax_unit_id = hoi_pr.organization_id

Line 1501: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;

1497: */
1498:
1499:
1500: procedure archinit(p_payroll_action_id in number) is
1501: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;
1502: l_state VARCHAR2(30);
1503: l_report_cat pay_report_format_mappings_f.report_category%TYPE;
1504:
1505: /* Bug 773937 */

Line 1535: FROM pay_state_rules sr

1531: -- Get jurisdiction code and store as a context
1532: IF l_state <> 'FED' THEN
1533: SELECT sr.jurisdiction_code
1534: INTO jurisdiction_code
1535: FROM pay_state_rules sr
1536: WHERE sr.state_code = l_state;
1537:
1538: /* Bug 976472 */
1539: g_sqwl_state := l_state;

Line 2841: pay_state_rules SR

2837: sqwl_range := 'SELECT distinct ASG.person_id
2838: FROM hr_organization_information HOI,
2839: per_assignments_f ASG,
2840: pay_us_asg_reporting puar,
2841: pay_state_rules SR
2842: WHERE SR.state_code = ''' || l_state || '''
2843: AND puar.jurisdiction_code like substr(SR.jurisdiction_code ,1,2)||''%''
2844: AND ASG.assignment_id = puar.assignment_id
2845: AND ASG.assignment_type = ''E''

Line 2867: pay_state_rules SR

2863: sqwl_range := 'SELECT distinct ASG.person_id
2864: FROM hr_organization_information HOI,
2865: per_assignments_f ASG,
2866: pay_us_asg_reporting puar,
2867: pay_state_rules SR
2868: WHERE SR.state_code = ''' || l_state || '''
2869: AND puar.jurisdiction_code like substr(SR.jurisdiction_code ,1,2)||''%''
2870: AND ASG.assignment_id = puar.assignment_id
2871: AND ASG.assignment_type = ''E''

Line 2902: pay_state_rules SR

2898: sqwl_range := 'SELECT distinct ASG.person_id
2899: FROM hr_organization_information HOI,
2900: per_assignments_f ASG,
2901: pay_us_asg_reporting puar,
2902: pay_state_rules SR
2903: WHERE SR.state_code = ''' || l_state || '''
2904: AND puar.jurisdiction_code like substr(SR.jurisdiction_code ,1,2)||''%''
2905: AND ASG.assignment_id = puar.assignment_id
2906: AND ASG.assignment_type = ''E''

Line 2931: pay_state_rules SR

2927: FROM pay_payrolls_f PPY,
2928: hr_organization_information HOI,
2929: per_assignments_f ASG,
2930: pay_us_asg_reporting puar,
2931: pay_state_rules SR
2932: WHERE SR.state_code = ''' || l_state || '''
2933: AND substr(SR.jurisdiction_code ,1,2) =
2934: substr(puar.jurisdiction_code,1,2)
2935: AND ASG.assignment_id = puar.assignment_id