APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_STATE_RULES

Line 557: from pay_state_rules SR

553: /* Get the jurisdiction_code for the specified state code. */
554:
555: cursor csr_jurisdiction_code is
556: select SR.jurisdiction_code
557: from pay_state_rules SR
558: where SR.state_code = p_state;
559:
560: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
561:

Line 560: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;

556: select SR.jurisdiction_code
557: from pay_state_rules SR
558: where SR.state_code = p_state;
559:
560: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
561:
562: begin
563:
564: open csr_jurisdiction_code;

Line 853: pay_state_rules SR

849: and ASG.assignment_type = 'E'
850: and ASG.business_group_id = ppa.business_group_id -- 5152728
851: and exists (select '1'
852: from pay_us_asg_reporting puar,
853: pay_state_rules SR
854: where SR.state_code = l_state
855: and substr(SR.jurisdiction_code ,1,2) =
856: substr(puar.jurisdiction_code,1,2)
857: and ASG.assignment_id = puar.assignment_id

Line 895: pay_state_rules SR

891: and ASG.assignment_type = 'E'
892: and ASG.business_group_id = ppa.business_group_id -- 5152728
893: and exists (select '1'
894: from pay_us_asg_reporting puar,
895: pay_state_rules SR
896: where SR.state_code = l_state
897: and substr(SR.jurisdiction_code ,1,2) =
898: substr(puar.jurisdiction_code,1,2)
899: and ASG.assignment_id = puar.assignment_id

Line 930: pay_state_rules SR

926: and ASG.assignment_type = 'E'
927: and ASG.business_group_id = ppa.business_group_id -- 5152728
928: and exists (select '1'
929: from pay_us_asg_reporting puar,
930: pay_state_rules SR
931: where SR.state_code = l_state
932: and substr(SR.jurisdiction_code ,1,2) =
933: substr(puar.jurisdiction_code,1,2)
934: and ASG.assignment_id = puar.assignment_id

Line 972: pay_state_rules SR

968: and ASG.assignment_type = 'E'
969: and ASG.business_group_id = ppa.business_group_id -- 5152728
970: and exists (select '1'
971: from pay_us_asg_reporting puar,
972: pay_state_rules SR
973: where SR.state_code = l_state
974: and substr(SR.jurisdiction_code ,1,2) =
975: substr(puar.jurisdiction_code,1,2)
976: and ASG.assignment_id = puar.assignment_id

Line 1009: pay_state_rules SR

1005: and ASG.person_id between stperson and endperson
1006: and ASG.assignment_type = 'E'
1007: and exists (select '1'
1008: from pay_us_asg_reporting puar,
1009: pay_state_rules SR
1010: where SR.state_code = l_state
1011: and substr(SR.jurisdiction_code ,1,2) =
1012: substr(puar.jurisdiction_code,1,2)
1013: and ASG.assignment_id = puar.assignment_id

Line 1050: pay_state_rules SR

1046: and ppr.person_id = ASG.person_id
1047: and ASG.assignment_type = 'E'
1048: and exists (select '1'
1049: from pay_us_asg_reporting puar,
1050: pay_state_rules SR
1051: where SR.state_code = l_state
1052: and substr(SR.jurisdiction_code ,1,2) =
1053: substr(puar.jurisdiction_code,1,2)
1054: and ASG.assignment_id = puar.assignment_id

Line 1088: pay_state_rules SR

1084: AND ASG.person_id between stperson and endperson
1085: and ASG.assignment_type = 'E'
1086: AND EXISTS (select 'x'
1087: from pay_us_asg_reporting puar,
1088: pay_state_rules SR
1089: where substr(SR.jurisdiction_code ,1,2) =
1090: substr(puar.jurisdiction_code,1,2)
1091: and ASG.assignment_id = puar.assignment_id
1092: and puar.tax_unit_id = hoi_pr.organization_id

Line 1139: pay_state_rules SR

1135: and ppr.person_id = ASG.person_id
1136: and ASG.assignment_type = 'E'
1137: AND EXISTS (select 'x'
1138: from pay_us_asg_reporting puar,
1139: pay_state_rules SR
1140: where substr(SR.jurisdiction_code ,1,2) =
1141: substr(puar.jurisdiction_code,1,2)
1142: and ASG.assignment_id = puar.assignment_id
1143: and puar.tax_unit_id = hoi_pr.organization_id

Line 1600: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;

1596: */
1597:
1598:
1599: procedure archinit(p_payroll_action_id in number) is
1600: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;
1601: l_state VARCHAR2(30);
1602: l_report_cat pay_report_format_mappings_f.report_category%TYPE;
1603:
1604: /* Bug 773937 */

Line 1634: FROM pay_state_rules sr

1630: -- Get jurisdiction code and store as a context
1631: IF l_state <> 'FED' THEN
1632: SELECT sr.jurisdiction_code
1633: INTO jurisdiction_code
1634: FROM pay_state_rules sr
1635: WHERE sr.state_code = l_state;
1636:
1637: /* Bug 976472 */
1638: g_sqwl_state := l_state;

Line 3834: pay_state_rules SR

3830: sqwl_range := 'SELECT distinct ASG.person_id
3831: FROM hr_organization_information HOI,
3832: per_assignments_f ASG,
3833: pay_us_asg_reporting puar,
3834: pay_state_rules SR
3835: WHERE SR.state_code = ''' || l_state || '''
3836: AND puar.jurisdiction_code like substr(SR.jurisdiction_code ,1,2)||''%''
3837: AND ASG.assignment_id = puar.assignment_id
3838: AND ASG.assignment_type = ''E''

Line 3861: pay_state_rules SR

3857: sqwl_range := 'SELECT distinct ASG.person_id
3858: FROM hr_organization_information HOI,
3859: per_assignments_f ASG,
3860: pay_us_asg_reporting puar,
3861: pay_state_rules SR
3862: WHERE SR.state_code = ''' || l_state || '''
3863: AND puar.jurisdiction_code like substr(SR.jurisdiction_code ,1,2)||''%''
3864: AND ASG.assignment_id = puar.assignment_id
3865: AND ASG.assignment_type = ''E''

Line 3897: pay_state_rules SR

3893: sqwl_range := 'SELECT distinct ASG.person_id
3894: FROM hr_organization_information HOI,
3895: per_assignments_f ASG,
3896: pay_us_asg_reporting puar,
3897: pay_state_rules SR
3898: WHERE SR.state_code = ''' || l_state || '''
3899: AND puar.jurisdiction_code like substr(SR.jurisdiction_code ,1,2)||''%''
3900: AND ASG.assignment_id = puar.assignment_id
3901: AND ASG.assignment_type = ''E''

Line 3927: pay_state_rules SR

3923: FROM pay_payrolls_f PPY,
3924: hr_organization_information HOI,
3925: per_assignments_f ASG,
3926: pay_us_asg_reporting puar,
3927: pay_state_rules SR
3928: WHERE SR.state_code = ''' || l_state || '''
3929: AND substr(SR.jurisdiction_code ,1,2) =
3930: substr(puar.jurisdiction_code,1,2)
3931: AND ASG.assignment_id = puar.assignment_id