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 110: per_all_assignments_f instead of per_assignments_f

106: join with business group id
107: 12-FEB-2002 sodhingr 115.21 2779152 Changed action_creation, added the
108: cursor c_state_pr, for PR.
109: 11-SEP-2002 sodhingr 115.20 2549213 Changed the foloowing cursors to user
110: per_all_assignments_f instead of per_assignments_f
111: c_ct_non_profit, c_state_la_quality, c_state
112: 30-MAY-2002 asasthan 115.19 2396909 For MMREF states SQWLs now
113: give warning when there is
114: no W2 Reporting Rules set up

Line 546: FROM per_assignments_f paf,

542: INTO l_resides_true
543: FROM dual
544: WHERE EXISTS (
545: SELECT '1'
546: FROM per_assignments_f paf,
547: per_addresses pad
548: WHERE paf.assignment_id = p_assignment_id AND
549: paf.person_id = pad.person_id AND
550: pad.date_from <= p_period_end AND

Line 728: l_prev_asg_id per_assignments_f.assignment_id%type;

724: checking against the new values returned from within the loop on the
725: next iteration. */
726:
727: l_prev_person_id per_people_f.person_id%type;
728: l_prev_asg_id per_assignments_f.assignment_id%type;
729: l_prev_tax_unit_id hr_organization_units.organization_id%type;
730:
731: /* Variable to hold the jurisdiction code used as a context for state
732: reporting. */

Line 1898: per_assignments_f paf1,

1894:
1895: cursor c_get_city is
1896: select distinct pcty.jurisdiction_code pcty
1897: from pay_us_emp_city_tax_rules_f pcty,
1898: per_assignments_f paf1,
1899: per_assignments_f paf
1900: where paf.assignment_id = asgid
1901: and paf.effective_end_date >= l_year_start
1902: and paf.effective_start_date <= l_year_end

Line 1899: per_assignments_f paf

1895: cursor c_get_city is
1896: select distinct pcty.jurisdiction_code pcty
1897: from pay_us_emp_city_tax_rules_f pcty,
1898: per_assignments_f paf1,
1899: per_assignments_f paf
1900: where paf.assignment_id = asgid
1901: and paf.effective_end_date >= l_year_start
1902: and paf.effective_start_date <= l_year_end
1903: and paf1.person_id = paf.person_id

Line 1930: -- per_assignments_f paf1,

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

Line 1931: -- per_assignments_f paf

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
1933: -- AND date_earned BETWEEN paf.effective_start_date
1934: -- AND paf.effective_end_date
1935: -- AND paf1.person_id = paf.person_id

Line 1980: -- per_assignments_f paf1,

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

Line 1981: -- per_assignments_f paf

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
1983: -- AND date_earned BETWEEN paf.effective_start_date
1984: -- AND paf.effective_end_date
1985: -- AND paf1.person_id = paf.person_id

Line 2451: FROM per_assignments_f paf,

2447: RETURN BOOLEAN IS
2448:
2449: CURSOR c_chk_asg_wp IS
2450: SELECT count(*) ct
2451: FROM per_assignments_f paf,
2452: per_assignment_extra_info paei
2453: WHERE paf.business_group_id = l_bus_group_id
2454: AND paf.effective_end_date >= l_period_start
2455: AND paf.effective_start_date <= l_period_end

Line 2589: FROM per_assignments_f ASG

2585:
2586: CURSOR c_asg_loc_mon ( p_ass_act_id number
2587: ,p_mon_of_qtr number) IS
2588: SELECT ASG.LOCATION_ID
2589: FROM per_assignments_f ASG
2590: , pay_assignment_actions ASSACT
2591: , pay_payroll_actions PACT
2592: WHERE ASSACT.assignment_action_id = p_ass_act_id
2593: AND ASSACT.payroll_action_id = PACT.payroll_action_id

Line 2611: FROM per_assignments_f paf,

2607:
2608: CURSOR c_asg_loc_end (p_ass_acti_id number) IS
2609: /*Commenting for bug 2510853
2610: SELECT paf.location_id
2611: FROM per_assignments_f paf,
2612: pay_assignment_actions paa,
2613: pay_payroll_actions ppa
2614: WHERE (paa.assignment_action_id = p_ass_acti_id
2615: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2627: FROM per_assignments_f paf1

2623: AND paa.assignment_id = paf.assignment_id
2624: AND ppa.business_group_id = paf.business_group_id
2625: AND paf.effective_end_date =
2626: (SELECT max(paf1.effective_end_date)
2627: FROM per_assignments_f paf1
2628: WHERE paf1.assignment_id = paf.assignment_id
2629: AND paf1.effective_end_date BETWEEN ppa.start_date
2630: AND ppa.effective_date
2631: )

Line 2636: FROM per_assignments_f paf,

2632: );
2633: */
2634:
2635: SELECT paf.location_id
2636: FROM per_assignments_f paf,
2637: pay_assignment_actions paa,
2638: pay_payroll_actions ppa
2639: WHERE paa.assignment_action_id = p_ass_acti_id
2640: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2649: FROM per_assignments_f paf1

2645: AND paf.effective_end_date)
2646: OR
2647: (paf.effective_end_date =
2648: (SELECT max(paf1.effective_end_date)
2649: FROM per_assignments_f paf1
2650: WHERE paf1.assignment_id = paf.assignment_id
2651: AND paf1.effective_end_date BETWEEN ppa.start_date
2652: AND ppa.effective_date)
2653: )

Line 2839: per_assignments_f ASG,

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

Line 2865: per_assignments_f ASG,

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

Line 2900: per_assignments_f ASG,

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

Line 2929: per_assignments_f ASG,

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