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 PER_ASSIGNMENTS_F

Line 164: per_all_assignments_f instead of per_assignments_f

160: join with business group id
161: 12-FEB-2002 sodhingr 115.21 2779152 Changed action_creation, added the
162: cursor c_state_pr, for PR.
163: 11-SEP-2002 sodhingr 115.20 2549213 Changed the foloowing cursors to user
164: per_all_assignments_f instead of per_assignments_f
165: c_ct_non_profit, c_state_la_quality, c_state
166: 30-MAY-2002 asasthan 115.19 2396909 For MMREF states SQWLs now
167: give warning when there is
168: no W2 Reporting Rules set up

Line 610: FROM per_assignments_f paf,

606: INTO l_resides_true
607: FROM dual
608: WHERE EXISTS (
609: SELECT '1'
610: FROM per_assignments_f paf,
611: per_addresses pad
612: WHERE paf.assignment_id = p_assignment_id AND
613: paf.person_id = pad.person_id AND
614: pad.date_from <= p_period_end AND

Line 797: l_prev_asg_id per_assignments_f.assignment_id%type;

793: checking against the new values returned from within the loop on the
794: next iteration. */
795:
796: l_prev_person_id per_people_f.person_id%type;
797: l_prev_asg_id per_assignments_f.assignment_id%type;
798: l_prev_tax_unit_id hr_organization_units.organization_id%type;
799:
800: /* Variable to hold the jurisdiction code used as a context for state
801: reporting. */

Line 1996: per_assignments_f paf1,

1992:
1993: cursor c_get_city is
1994: select distinct pcty.jurisdiction_code pcty
1995: from pay_us_emp_city_tax_rules_f pcty,
1996: per_assignments_f paf1,
1997: per_assignments_f paf
1998: where paf.assignment_id = asgid
1999: and paf.effective_end_date >= l_year_start
2000: and paf.effective_start_date <= l_year_end

Line 1997: per_assignments_f paf

1993: cursor c_get_city is
1994: select distinct pcty.jurisdiction_code pcty
1995: from pay_us_emp_city_tax_rules_f pcty,
1996: per_assignments_f paf1,
1997: per_assignments_f paf
1998: where paf.assignment_id = asgid
1999: and paf.effective_end_date >= l_year_start
2000: and paf.effective_start_date <= l_year_end
2001: and paf1.person_id = paf.person_id

Line 2028: -- per_assignments_f paf1,

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
2031: -- AND date_earned BETWEEN paf.effective_start_date
2032: -- AND paf.effective_end_date

Line 2029: -- per_assignments_f paf

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
2031: -- AND date_earned BETWEEN paf.effective_start_date
2032: -- AND paf.effective_end_date
2033: -- AND paf1.person_id = paf.person_id

Line 2078: -- per_assignments_f paf1,

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
2081: -- AND date_earned BETWEEN paf.effective_start_date
2082: -- AND paf.effective_end_date

Line 2079: -- per_assignments_f paf

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
2081: -- AND date_earned BETWEEN paf.effective_start_date
2082: -- AND paf.effective_end_date
2083: -- AND paf1.person_id = paf.person_id

Line 3388: FROM per_assignments_f paf,

3384: RETURN BOOLEAN IS
3385:
3386: CURSOR c_chk_asg_wp IS
3387: SELECT count(*) ct
3388: FROM per_assignments_f paf,
3389: per_assignment_extra_info paei
3390: WHERE paf.business_group_id = l_bus_group_id
3391: AND paf.effective_end_date >= l_period_start
3392: AND paf.effective_start_date <= l_period_end

Line 3526: FROM per_assignments_f ASG

3522:
3523: CURSOR c_asg_loc_mon ( p_ass_act_id number
3524: ,p_mon_of_qtr number) IS
3525: SELECT ASG.LOCATION_ID
3526: FROM per_assignments_f ASG
3527: , pay_assignment_actions ASSACT
3528: , pay_payroll_actions PACT
3529: WHERE ASSACT.assignment_action_id = p_ass_act_id
3530: AND ASSACT.payroll_action_id = PACT.payroll_action_id

Line 3539: FROM per_assignments_f ASG

3535:
3536: CURSOR c_asg_loc_mon2 ( p_ass_act_id number
3537: ,p_mon_of_qtr number) IS
3538: SELECT ASG.LOCATION_ID
3539: FROM per_assignments_f ASG
3540: , pay_assignment_actions ASSACT
3541: , pay_payroll_actions PACT
3542: WHERE ASSACT.assignment_action_id = p_ass_act_id
3543: AND ASSACT.payroll_action_id = PACT.payroll_action_id

Line 3565: FROM per_assignments_f paf,

3561:
3562: CURSOR c_asg_loc_end (p_ass_acti_id number) IS
3563: /*Commenting for bug 2510853
3564: SELECT paf.location_id
3565: FROM per_assignments_f paf,
3566: pay_assignment_actions paa,
3567: pay_payroll_actions ppa
3568: WHERE (paa.assignment_action_id = p_ass_acti_id
3569: AND paa.payroll_action_id = ppa.payroll_action_id

Line 3581: FROM per_assignments_f paf1

3577: AND paa.assignment_id = paf.assignment_id
3578: AND ppa.business_group_id = paf.business_group_id
3579: AND paf.effective_end_date =
3580: (SELECT max(paf1.effective_end_date)
3581: FROM per_assignments_f paf1
3582: WHERE paf1.assignment_id = paf.assignment_id
3583: AND paf1.effective_end_date BETWEEN ppa.start_date
3584: AND ppa.effective_date
3585: )

Line 3590: FROM per_assignments_f paf,

3586: );
3587: */
3588:
3589: SELECT paf.location_id
3590: FROM per_assignments_f paf,
3591: pay_assignment_actions paa,
3592: pay_payroll_actions ppa
3593: WHERE paa.assignment_action_id = p_ass_acti_id
3594: AND paa.payroll_action_id = ppa.payroll_action_id

Line 3603: FROM per_assignments_f paf1

3599: AND paf.effective_end_date)
3600: OR
3601: (paf.effective_end_date =
3602: (SELECT max(paf1.effective_end_date)
3603: FROM per_assignments_f paf1
3604: WHERE paf1.assignment_id = paf.assignment_id
3605: AND paf1.effective_end_date BETWEEN ppa.start_date
3606: AND ppa.effective_date)
3607: )

Line 3832: per_assignments_f ASG,

3828:
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)||''%''

Line 3859: per_assignments_f ASG,

3855:
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)||''%''

Line 3895: per_assignments_f ASG,

3891: IF ((l_preprocess_flag = TRUE AND l_state = 'CA') OR
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)||''%''

Line 3925: per_assignments_f ASG,

3921: /* commented by saurgupt for testing
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) =