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 247: now using pay_us_asg_reporting.

243: 04-DEC-1998 vmehta 750802 Changed the cursors/logic to
244: pick up people who live in
245: California for the California SQWL.
246: 29-NOV-1998 nbristow Changes to the SQWL code,
247: now using pay_us_asg_reporting.
248: 25-Sep-1998 vmehta Changed the range cursor and
249: the assignment_action creation
250: cursors to support Louisiana
251: Quality Jobs Program Reporting.

Line 782: from pay_us_asg_reporting puar,

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

Line 824: from pay_us_asg_reporting puar,

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

Line 859: from pay_us_asg_reporting puar,

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

Line 901: from pay_us_asg_reporting puar,

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

Line 938: from pay_us_asg_reporting puar,

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

Line 979: from pay_us_asg_reporting puar,

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

Line 1017: from pay_us_asg_reporting puar,

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

Line 1068: from pay_us_asg_reporting puar,

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

Line 1928: -- pay_us_asg_reporting puar,

1924: -- CURSOR c_archive_wage_plan_code_rtm IS
1925: -- SELECT DISTINCT aei_information3 ,
1926: -- paf1.assignment_id
1927: -- FROM per_assignment_extra_info paei,
1928: -- pay_us_asg_reporting puar,
1929: -- pay_us_states pus ,
1930: -- per_assignments_f paf1,
1931: -- per_assignments_f paf
1932: -- WHERE paf.assignment_id = asgid

Line 1949: -- pay_us_asg_reporting puar1

1945: -- AND EXISTS(
1946: -- SELECT NULL
1947: -- FROM pay_payroll_actions ppa1,
1948: -- pay_assignment_actions paa1,
1949: -- pay_us_asg_reporting puar1
1950: -- WHERE paa1.assignment_id = paf1.assignment_id
1951: -- AND ppa1.payroll_action_id = paa1.payroll_action_id
1952: -- AND puar1.assignment_id = paf1.assignment_id
1953: -- AND puar1.tax_unit_id = puar.tax_unit_id

Line 1978: -- pay_us_asg_reporting puar,

1974: -- CURSOR c_archive_wage_plan_code_rts IS
1975: -- SELECT DISTINCT aei_information3 ,
1976: -- paf1.assignment_id
1977: -- FROM per_assignment_extra_info paei,
1978: -- pay_us_asg_reporting puar,
1979: -- pay_us_states pus ,
1980: -- per_assignments_f paf1,
1981: -- per_assignments_f paf
1982: -- WHERE paf.assignment_id = asgid

Line 1999: -- pay_us_asg_reporting puar1

1995: -- AND EXISTS(
1996: -- SELECT NULL
1997: -- FROM pay_payroll_actions ppa1,
1998: -- pay_assignment_actions paa1,
1999: -- pay_us_asg_reporting puar1
2000: -- WHERE paa1.assignment_id = paf1.assignment_id
2001: -- AND ppa1.payroll_action_id = paa1.payroll_action_id
2002: -- AND puar1.assignment_id = paf1.assignment_id
2003: -- AND puar1.tax_unit_id = puar.tax_unit_id

Line 2840: pay_us_asg_reporting puar,

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

Line 2866: pay_us_asg_reporting puar,

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

Line 2901: pay_us_asg_reporting puar,

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

Line 2930: pay_us_asg_reporting puar,

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