eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_US_ASG_REPORTING

Line 301: now using pay_us_asg_reporting.

297: 04-DEC-1998 vmehta 750802 Changed the cursors/logic to
298: pick up people who live in
299: California for the California SQWL.
300: 29-NOV-1998 nbristow Changes to the SQWL code,
301: now using pay_us_asg_reporting.
302: 25-Sep-1998 vmehta Changed the range cursor and
303: the assignment_action creation
304: cursors to support Louisiana
305: Quality Jobs Program Reporting.

Line 852: from pay_us_asg_reporting puar,

848: and ASG.person_id between stperson and endperson
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)

Line 894: from pay_us_asg_reporting puar,

890: and ppr.person_id = ASG.person_id
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)

Line 929: from pay_us_asg_reporting puar,

925: and ASG.person_id between stperson and endperson
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)

Line 971: from pay_us_asg_reporting puar,

967: and asg.person_id = ppr.person_id
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)

Line 1008: from pay_us_asg_reporting puar,

1004: and ASG.business_group_id + 0 = l_bus_group_id
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)

Line 1049: from pay_us_asg_reporting puar,

1045: and ppr.chunk_number = chunk
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)

Line 1087: from pay_us_asg_reporting puar,

1083: AND ASG.business_group_id + 0 = l_bus_group_id
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

Line 1138: from pay_us_asg_reporting puar,

1134: and ppr.chunk_number = chunk
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

Line 2026: -- pay_us_asg_reporting puar,

2022: -- CURSOR c_archive_wage_plan_code_rtm IS
2023: -- SELECT DISTINCT aei_information3 ,
2024: -- paf1.assignment_id
2025: -- FROM per_assignment_extra_info paei,
2026: -- pay_us_asg_reporting puar,
2027: -- pay_us_states pus ,
2028: -- per_assignments_f paf1,
2029: -- per_assignments_f paf
2030: -- WHERE paf.assignment_id = asgid

Line 2047: -- pay_us_asg_reporting puar1

2043: -- AND EXISTS(
2044: -- SELECT NULL
2045: -- FROM pay_payroll_actions ppa1,
2046: -- pay_assignment_actions paa1,
2047: -- pay_us_asg_reporting puar1
2048: -- WHERE paa1.assignment_id = paf1.assignment_id
2049: -- AND ppa1.payroll_action_id = paa1.payroll_action_id
2050: -- AND puar1.assignment_id = paf1.assignment_id
2051: -- AND puar1.tax_unit_id = puar.tax_unit_id

Line 2076: -- pay_us_asg_reporting puar,

2072: -- CURSOR c_archive_wage_plan_code_rts IS
2073: -- SELECT DISTINCT aei_information3 ,
2074: -- paf1.assignment_id
2075: -- FROM per_assignment_extra_info paei,
2076: -- pay_us_asg_reporting puar,
2077: -- pay_us_states pus ,
2078: -- per_assignments_f paf1,
2079: -- per_assignments_f paf
2080: -- WHERE paf.assignment_id = asgid

Line 2097: -- pay_us_asg_reporting puar1

2093: -- AND EXISTS(
2094: -- SELECT NULL
2095: -- FROM pay_payroll_actions ppa1,
2096: -- pay_assignment_actions paa1,
2097: -- pay_us_asg_reporting puar1
2098: -- WHERE paa1.assignment_id = paf1.assignment_id
2099: -- AND ppa1.payroll_action_id = paa1.payroll_action_id
2100: -- AND puar1.assignment_id = paf1.assignment_id
2101: -- AND puar1.tax_unit_id = puar.tax_unit_id

Line 3833: pay_us_asg_reporting puar,

3829: if (l_state = 'LA' and l_report_cat = 'RTLAQ') then
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

Line 3860: pay_us_asg_reporting puar,

3856: elsif (l_state = 'CT' and l_report_cat = 'RTCTN') then
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

Line 3896: pay_us_asg_reporting puar,

3892: l_state <> 'CA') THEN
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

Line 3926: pay_us_asg_reporting puar,

3922: sqwl_range := 'SELECT distinct ASG.person_id
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)