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_ALL_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 762: FROM per_all_assignments_f ASG,

758: ASG.person_id person_id,
759: ASG.assignment_id assignment_id,
760: paa.tax_unit_id tax_unit_id,
761: ppa.effective_date effective_end_date
762: FROM per_all_assignments_f ASG,
763: pay_assignment_actions paa,
764: pay_payroll_actions ppa
765: WHERE ppa.effective_date between l_period_start
766: and l_period_end

Line 800: FROM per_all_assignments_f ASG,

796: ASG.person_id person_id,
797: ASG.assignment_id assignment_id,
798: paa.tax_unit_id tax_unit_id,
799: ppa.effective_date effective_end_date
800: FROM per_all_assignments_f ASG,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_population_ranges ppr
804: WHERE ppa.effective_date between l_period_start

Line 839: FROM per_all_assignments_f ASG,

835: ASG.person_id person_id,
836: ASG.assignment_id assignment_id,
837: paa.tax_unit_id tax_unit_id,
838: ppa.effective_date effective_end_date
839: FROM per_all_assignments_f ASG,
840: pay_assignment_actions paa,
841: pay_payroll_actions ppa
842: WHERE ppa.effective_date between l_period_start
843: and l_period_end

Line 877: FROM per_all_assignments_f ASG,

873: ASG.person_id person_id,
874: ASG.assignment_id assignment_id,
875: paa.tax_unit_id tax_unit_id,
876: ppa.effective_date effective_end_date
877: FROM per_all_assignments_f ASG,
878: pay_assignment_actions paa,
879: pay_payroll_actions ppa,
880: pay_population_ranges ppr
881: WHERE ppa.effective_date between l_period_start

Line 919: FROM per_all_assignments_f ASG,

915: ASG.person_id person_id,
916: ASG.assignment_id assignment_id,
917: paa.tax_unit_id tax_unit_id,
918: ppa.effective_date effective_end_date
919: FROM per_all_assignments_f ASG,
920: pay_assignment_actions paa,
921: pay_payroll_actions ppa
922: WHERE ppa.effective_date between l_period_start
923: and l_period_end

Line 956: FROM per_all_assignments_f ASG,

952: ASG.person_id person_id,
953: ASG.assignment_id assignment_id,
954: paa.tax_unit_id tax_unit_id,
955: ppa.effective_date effective_end_date
956: FROM per_all_assignments_f ASG,
957: pay_assignment_actions paa,
958: pay_payroll_actions ppa,
959: pay_population_ranges ppr
960: WHERE ppa.effective_date between l_period_start

Line 995: FROM per_all_assignments_f ASG,

991: SELECT ASG.person_id person_id,
992: ASG.assignment_id assignment_id,
993: paa.tax_unit_id tax_unit_id,
994: ppa.effective_date effective_end_date
995: FROM per_all_assignments_f ASG,
996: pay_assignment_actions paa,
997: pay_payroll_actions ppa,
998: hr_organization_information HOI_PR
999: WHERE ppa.effective_date between l_period_start and l_period_end

Line 1042: FROM per_all_assignments_f ASG,

1038: SELECT ASG.person_id person_id,
1039: ASG.assignment_id assignment_id,
1040: paa.tax_unit_id tax_unit_id,
1041: ppa.effective_date effective_end_date
1042: FROM per_all_assignments_f ASG,
1043: pay_assignment_actions paa,
1044: pay_payroll_actions ppa,
1045: hr_organization_information HOI_PR,
1046: pay_population_ranges ppr

Line 2045: per_all_assignments_f paf,

2041: CURSOR c_get_latest_asg(p_assignment_id number ) IS
2042: select paa.assignment_action_id,
2043: ppa.effective_date
2044: from pay_assignment_actions paa,
2045: per_all_assignments_f paf,
2046: pay_payroll_actions ppa,
2047: pay_action_classifications pac,
2048: per_all_assignments_f paf1
2049: where paf1.assignment_id = p_assignment_id

Line 2048: per_all_assignments_f paf1

2044: from pay_assignment_actions paa,
2045: per_all_assignments_f paf,
2046: pay_payroll_actions ppa,
2047: pay_action_classifications pac,
2048: per_all_assignments_f paf1
2049: where paf1.assignment_id = p_assignment_id
2050: and paf.person_id = paf1.person_id
2051: and paa.assignment_id = paf.assignment_id
2052: and paa.tax_unit_id = taxunitid

Line 2076: FROM PER_ALL_ASSIGNMENTS_F PAF1,

2072: CURSOR c_get_latest_asg(p_assignment_id number ) IS
2073: SELECT /*+ORDERED*/
2074: PAA.ASSIGNMENT_ACTION_ID,
2075: PPA.EFFECTIVE_DATE
2076: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2077: PER_ALL_ASSIGNMENTS_F PAF ,
2078: PAY_ASSIGNMENT_ACTIONS PAA,
2079: PAY_PAYROLL_ACTIONS PPA ,
2080: PAY_ACTION_CLASSIFICATIONS PAC

Line 2077: PER_ALL_ASSIGNMENTS_F PAF ,

2073: SELECT /*+ORDERED*/
2074: PAA.ASSIGNMENT_ACTION_ID,
2075: PPA.EFFECTIVE_DATE
2076: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2077: PER_ALL_ASSIGNMENTS_F PAF ,
2078: PAY_ASSIGNMENT_ACTIONS PAA,
2079: PAY_PAYROLL_ACTIONS PPA ,
2080: PAY_ACTION_CLASSIFICATIONS PAC
2081: WHERE PAF1.ASSIGNMENT_ID = p_assignment_id

Line 2599: l_location_id per_all_assignments_f.location_id%type;

2595: AND add_months(trunc (PACT.effective_date, 'Q'), p_mon_of_qtr - 1) + 11
2596: BETWEEN ASG.effective_start_date
2597: AND ASG.Effective_end_date;
2598:
2599: l_location_id per_all_assignments_f.location_id%type;
2600: l_user_entity_id ff_user_entities.user_entity_id%type;
2601: l_archive_item_id ff_archive_items.archive_item_id%type;
2602: l_object_version_number ff_archive_items.object_version_number%type;
2603: l_some_warning boolean;