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_PSD_XML dependencies on PER_ALL_ASSIGNMENTS_F

Line 907: FROM per_all_assignments_f paf

903: -- Cursor to check if employee selected is work at home employee
904:
905: CURSOR c_get_wah_flag(l_asg_id number, l_effective_date date) IS
906: SELECT paf.work_at_home
907: FROM per_all_assignments_f paf
908: WHERE assignment_id = l_asg_id
909: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
910:
911: -- Cursor to check if that particular psd code is defined in the psd rules for that gre

Line 1321: per_all_assignments_f ASG,

1317: IF l_period_type <> 'Yearly' then
1318:
1319: p_sqlstr := 'SELECT distinct ASG.person_id
1320: FROM hr_organization_information HOI,
1321: per_all_assignments_f ASG,
1322: pay_us_asg_reporting puar,
1323: pay_state_rules SR
1324: WHERE SR.state_code = '''||l_state_abbrev||'''
1325: AND puar.jurisdiction_code like substr(SR.jurisdiction_code ,1,2)||''%''

Line 1348: per_all_assignments_f paf,

1344: --Modified for the Bug 15944697
1345: p_sqlstr := 'SELECT DISTINCT to_number(paa.serial_number)
1346: FROM pay_assignment_actions paa,
1347: pay_payroll_actions ppa,
1348: per_all_assignments_f paf,
1349: pay_payroll_actions ppa1,
1350: pay_us_asg_reporting puar,
1351: pay_state_rules SR
1352: WHERE ppa1.payroll_action_id = :payroll_action_id

Line 1566: FROM per_all_assignments_f ASG,

1562: ASG.person_id person_id,
1563: ASG.assignment_id assignment_id,
1564: paa.tax_unit_id tax_unit_id,
1565: ppa.effective_date effective_end_date
1566: FROM per_all_assignments_f ASG,
1567: pay_assignment_actions paa,
1568: pay_payroll_actions ppa
1569: WHERE ppa.effective_date between l_period_start
1570: and l_period_end

Line 1600: FROM per_all_assignments_f ASG,

1596: ASG.person_id person_id,
1597: ASG.assignment_id assignment_id,
1598: paa.tax_unit_id tax_unit_id,
1599: ppa.effective_date effective_end_date
1600: FROM per_all_assignments_f ASG,
1601: pay_assignment_actions paa,
1602: pay_payroll_actions ppa,
1603: pay_population_ranges ppr
1604: WHERE ppa.effective_date between l_period_start

Line 1639: FROM per_all_assignments_f ASG,

1635: ASG.assignment_id assignment_id,
1636: paa.tax_unit_id tax_unit_id,
1637: ppa.effective_date effective_end_date,
1638: paa.assignment_action_id act_id
1639: FROM per_all_assignments_f ASG,
1640: pay_assignment_actions paa,
1641: pay_payroll_actions ppa
1642: WHERE ppa.effective_date = l_period_end
1643: and ppa.report_type = 'YREND'

Line 1673: FROM per_all_assignments_f ASG,

1669: ASG.assignment_id assignment_id,
1670: paa.tax_unit_id tax_unit_id,
1671: ppa.effective_date effective_end_date,
1672: paa.assignment_action_id act_id
1673: FROM per_all_assignments_f ASG,
1674: pay_assignment_actions paa,
1675: pay_payroll_actions ppa,
1676: pay_population_ranges ppr
1677: WHERE ppa.effective_date= l_period_end

Line 1717: FROM PER_ALL_ASSIGNMENTS_F PAF,

1713: CURSOR c_get_latest_asg(l_person_id number ) IS
1714: SELECT /*+ORDERED*/
1715: PAA.ASSIGNMENT_ACTION_ID,
1716: PPA.EFFECTIVE_DATE
1717: FROM PER_ALL_ASSIGNMENTS_F PAF,
1718: PAY_ASSIGNMENT_ACTIONS PAA,
1719: PAY_PAYROLL_ACTIONS PPA ,
1720: PAY_ACTION_CLASSIFICATIONS PAC
1721: WHERE PAF.PERSON_ID = l_person_id

Line 1744: per_all_Assignments_f paf

1740: cursor c_get_jurisdiction (cp_person_id number
1741: ,cp_tax_unit_id number) is
1742: select distinct puar.jurisdiction_code
1743: from pay_us_asg_reporting puar,
1744: per_all_Assignments_f paf
1745: where puar.assignment_id = paf.assignment_id
1746: and paf.person_id = cp_person_id
1747: and puar.tax_unit_id = cp_tax_unit_id
1748: and length(puar.jurisdiction_code)=16

Line 2858: per_all_Assignments_f paf

2854: cursor c_get_jurisdiction (cp_person_id number
2855: ,cp_tax_unit_id number) is
2856: select distinct puar.jurisdiction_code
2857: from pay_us_asg_reporting puar,
2858: per_all_Assignments_f paf
2859: where puar.assignment_id = paf.assignment_id
2860: and paf.person_id=cp_person_id
2861: and puar.tax_unit_id = cp_tax_unit_id
2862: and length(puar.jurisdiction_code)=16;

Line 2884: FROM PER_ALL_ASSIGNMENTS_F PAF1,

2880: CURSOR c_get_latest_asg(p_assignment_id number ) IS
2881: SELECT /*+ORDERED*/
2882: PAA.ASSIGNMENT_ACTION_ID,
2883: PPA.EFFECTIVE_DATE
2884: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2885: PER_ALL_ASSIGNMENTS_F PAF ,
2886: PAY_ASSIGNMENT_ACTIONS PAA,
2887: PAY_PAYROLL_ACTIONS PPA ,
2888: PAY_ACTION_CLASSIFICATIONS PAC

Line 2885: PER_ALL_ASSIGNMENTS_F PAF ,

2881: SELECT /*+ORDERED*/
2882: PAA.ASSIGNMENT_ACTION_ID,
2883: PPA.EFFECTIVE_DATE
2884: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2885: PER_ALL_ASSIGNMENTS_F PAF ,
2886: PAY_ASSIGNMENT_ACTIONS PAA,
2887: PAY_PAYROLL_ACTIONS PPA ,
2888: PAY_ACTION_CLASSIFICATIONS PAC
2889: WHERE PAF1.ASSIGNMENT_ID = p_assignment_id

Line 2917: from per_all_assignments_f ASSIGN

2913: PEOPLE.last_name,
2914: PEOPLE.employee_number,
2915: PEOPLE.suffix,
2916: replace(PEOPLE.national_identifier,' ')
2917: from per_all_assignments_f ASSIGN
2918: ,per_all_people_f PEOPLE
2919: where ASSIGN.assignment_id =l_asgid
2920: and PEOPLE.person_id = ASSIGN.person_id
2921: and l_date_earned BETWEEN ASSIGN.effective_start_date

Line 2997: from per_all_assignments_f

2993: close c_get_latest_asg;
2994:
2995: -- Added for Bug 14640336
2996: /* select person_id into l_person_id
2997: from per_all_assignments_f
2998: where assignment_id=l_asgid;*/
2999:
3000: --Modified for the Bug 14690909
3001: select serial_number into l_person_id