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_OVER_LIMIT_TAX_RPT_PKG dependencies on PER_ASSIGNMENTS_F

Line 55: and removed per_assignments_f table

51: at a wrong place in load_federal_balance.
52: this was causing report to error out
53: with invalid cursor error.
54: 20-MAR-2002 meshah 115.9 changed the date checking in load_data
55: and removed per_assignments_f table
56: from load_state_data.
57: 27-MAR-2002 meshah 115.10 2280318 the call to get_tax_balances has been
58: changed. Instead of calling it in the
59: sql statement we are calling it in a

Line 776: l_assignment_number per_assignments_f.assignment_number%type;

772:
773: l_jurisdiction_code pay_us_emp_state_tax_rules_f.jurisdiction_code%type;
774:
775: -- #2938556
776: l_assignment_number per_assignments_f.assignment_number%type;
777: l_person_id per_assignments_f.person_id%type;
778: l_first_name per_people_f.first_name%type;
779: l_middle_name per_people_f.middle_names%type;
780: l_last_name per_people_f.last_name%type;

Line 777: l_person_id per_assignments_f.person_id%type;

773: l_jurisdiction_code pay_us_emp_state_tax_rules_f.jurisdiction_code%type;
774:
775: -- #2938556
776: l_assignment_number per_assignments_f.assignment_number%type;
777: l_person_id per_assignments_f.person_id%type;
778: l_first_name per_people_f.first_name%type;
779: l_middle_name per_people_f.middle_names%type;
780: l_last_name per_people_f.last_name%type;
781: l_ssn per_people_f.national_identifier%type;

Line 882: from per_assignments_f paf

878: ,l_first_name
879: ,l_middle_name
880: ,l_last_name
881: ,l_ssn
882: from per_assignments_f paf
883: ,per_people_f ppf
884: where paf.assignment_id = p_asg_id
885: and paf.effective_end_date = ( select max(paf1.effective_end_date)
886: from per_assignments_f paf1

Line 886: from per_assignments_f paf1

882: from per_assignments_f paf
883: ,per_people_f ppf
884: where paf.assignment_id = p_asg_id
885: and paf.effective_end_date = ( select max(paf1.effective_end_date)
886: from per_assignments_f paf1
887: where paf1.assignment_id = paf.assignment_id
888: and paf1.effective_start_date <= p_as_of_date)
889: and ppf.person_id = paf.person_id
890: and p_as_of_date between ppf.effective_start_date and ppf.effective_end_date;

Line 1079: l_assignment_number per_assignments_f.assignment_number%type;

1075:
1076:
1077:
1078: -- #2938556
1079: l_assignment_number per_assignments_f.assignment_number%type;
1080: l_person_id per_assignments_f.person_id%type;
1081: l_first_name per_people_f.first_name%type;
1082: l_middle_name per_people_f.middle_names%type;
1083: l_last_name per_people_f.last_name%type;

Line 1080: l_person_id per_assignments_f.person_id%type;

1076:
1077:
1078: -- #2938556
1079: l_assignment_number per_assignments_f.assignment_number%type;
1080: l_person_id per_assignments_f.person_id%type;
1081: l_first_name per_people_f.first_name%type;
1082: l_middle_name per_people_f.middle_names%type;
1083: l_last_name per_people_f.last_name%type;
1084: l_ssn per_people_f.national_identifier%type;

Line 1344: from per_assignments_f paf

1340: ,l_first_name
1341: ,l_middle_name
1342: ,l_last_name
1343: ,l_ssn
1344: from per_assignments_f paf
1345: ,per_people_f ppf
1346: where paf.assignment_id = p_asg_id
1347: and paf.effective_end_date = ( select max(paf1.effective_end_date)
1348: from per_assignments_f paf1

Line 1348: from per_assignments_f paf1

1344: from per_assignments_f paf
1345: ,per_people_f ppf
1346: where paf.assignment_id = p_asg_id
1347: and paf.effective_end_date = ( select max(paf1.effective_end_date)
1348: from per_assignments_f paf1
1349: where paf1.assignment_id = paf.assignment_id
1350: and paf1.effective_start_date <= p_as_of_date)
1351: and ppf.person_id = paf.person_id
1352: and p_as_of_date between ppf.effective_start_date and ppf.effective_end_date;

Line 1439: per_assignments_f paf,

1435: paf.effective_end_date max_end_date
1436: from hr_locations_all hrl,
1437: hr_all_organization_units hou1,
1438: hr_all_organization_units hou,
1439: per_assignments_f paf,
1440: pay_assignment_actions paa, -- PYUGEN
1441: pay_payroll_actions ppa_arch -- PYUGEN
1442: where
1443: -- ppa_arch.payroll_action_id = l_pactid

Line 1449: from per_assignments_f paf1

1445: and paa.payroll_action_id = ppa_arch.payroll_action_id
1446: -- and paa.chunk_number = l_chnkno
1447: and paf.assignment_id = paa.assignment_id
1448: and paf.effective_end_date = ( select max(effective_end_date)
1449: from per_assignments_f paf1
1450: where paf1.assignment_id = paf.assignment_id
1451: and paf1.effective_start_date <=
1452: ppa_arch.effective_date
1453: )

Line 1458: l_bal_date per_assignments_f.effective_end_date%TYPE;

1454: and hrl.location_id = NVL(paf.location_id,hou.location_id)
1455: and hou1.organization_id = nvl(paf.organization_id,paf.business_group_id)
1456: and hou.organization_id = paa.tax_unit_id;
1457:
1458: l_bal_date per_assignments_f.effective_end_date%TYPE;
1459: new_asg_act_id pay_assignment_actions.assignment_action_id%type;
1460: --
1461: --
1462: --------------------------- M A I N -------------------------------------