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

Line 285: per_all_assignments_f instead of

281: A_TERRITORY_TAXABLE_RETIREMENT_CONTRIBUTION_PER_GRE_YTD to
282: A_TERRITORY_RETIREMENT_CONTRIB_PER_GRE_YTD
283:
284: 14-AUG-2001 SSarma 40.46 EOY 2001: Changes for security.
285: per_all_assignments_f instead of
286: per_assignmentes_f.
287: New items archived for Employer.
288: Legislation code checks for
289: ff_user_entities join.

Line 1468: FROM per_all_assignments_f ASG,

1464: ,cp_start_person_id in number
1465: ,cp_end_person_id in number) is
1466: SELECT DISTINCT
1467: ASG.person_id person_id
1468: FROM per_all_assignments_f ASG,
1469: pay_all_payrolls_f PPY
1470: WHERE exists
1471: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1472: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

Line 1501: per_all_assignments_f asg,

1497: ,cp_chunk_number in number) is
1498: select DISTINCT
1499: asg.person_id person_id
1500: from pay_population_ranges ppr,
1501: per_all_assignments_f asg,
1502: pay_all_payrolls_f ppy
1503: where exists
1504: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1505: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

Line 1532: from per_all_assignments_f paf

1528: CURSOR c_get_asg_id(cp_person_id in number
1529: ,cp_period_start in date
1530: ,cp_period_end in date) IS
1531: SELECT assignment_id
1532: from per_all_assignments_f paf
1533: where person_id = cp_person_id
1534: and primary_flag = 'Y'
1535: and assignment_type = 'E'
1536: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 1537: from per_all_assignments_f paf2

1533: where person_id = cp_person_id
1534: and primary_flag = 'Y'
1535: and assignment_type = 'E'
1536: and paf.effective_start_date = (select max(paf2.effective_start_date)
1537: from per_all_assignments_f paf2
1538: where paf2.primary_flag = 'Y'
1539: and paf2.assignment_type = 'E'
1540: and paf2.effective_start_date <= cp_period_end
1541: and paf2.effective_end_date >= cp_period_start

Line 1558: per_all_assignments_f paf,

1554: ,cp_period_end in date) IS
1555: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
1556: ||lpad(paa.assignment_action_id,15,'0')),16))
1557: from pay_assignment_actions paa,
1558: per_all_assignments_f paf,
1559: pay_payroll_actions ppa,
1560: pay_action_classifications pac
1561: where paf.person_id = cp_person_id
1562: and paa.assignment_id = paf.assignment_id

Line 3636: per_all_assignments_f paf1

3632: cursor c_get_city is
3633: select distinct pcty.jurisdiction_code pcty
3634: from pay_us_city_tax_info_f cti,
3635: pay_us_emp_city_tax_rules_f pcty,
3636: per_all_assignments_f paf1
3637: where paf1.person_id = l_person_id
3638: and paf1.effective_end_date >= l_year_start
3639: and paf1.effective_start_date <= l_year_end
3640: and pcty.assignment_id = paf1.assignment_id

Line 3656: per_all_assignments_f paf1

3652: /*
3653: cursor c_get_county is
3654: select distinct pcnt.jurisdiction_code
3655: from pay_us_emp_county_tax_rules_f pcnt,
3656: per_all_assignments_f paf1
3657: where paf1.person_id = l_person_id
3658: and paf1.effective_end_date >= l_year_start
3659: and paf1.effective_start_date <= l_year_end
3660: and pcnt.assignment_id = paf1.assignment_id

Line 3669: per_all_assignments_f paf1

3665: cursor c_get_county is
3666: select distinct pcnt.jurisdiction_code
3667: from pay_us_county_tax_info_f cnti,
3668: pay_us_emp_county_tax_rules_f pcnt,
3669: per_all_assignments_f paf1
3670: where paf1.person_id = l_person_id
3671: and paf1.effective_end_date >= l_year_start
3672: and paf1.effective_start_date <= l_year_end
3673: and pcnt.assignment_id = paf1.assignment_id

Line 3689: per_all_assignments_f paf1

3685: cursor c_get_state is
3686: select distinct pst.jurisdiction_code
3687: from pay_us_state_tax_info_f sti,
3688: pay_us_emp_state_tax_rules_f pst,
3689: per_all_assignments_f paf1
3690: where paf1.person_id = l_person_id
3691: and paf1.effective_end_date >= l_year_start
3692: and paf1.effective_start_date <= l_year_end
3693: and paf1.assignment_id = pst.assignment_id

Line 3705: per_all_assignments_f paf1

3701:
3702: cursor c_get_state is
3703: select distinct pst.jurisdiction_code
3704: from pay_us_emp_state_tax_rules_f pst,
3705: per_all_assignments_f paf1
3706: where paf1.person_id = l_person_id
3707: and paf1.effective_end_date >= l_year_start
3708: and paf1.effective_start_date <= l_year_end
3709: and paf1.assignment_id = pst.assignment_id

Line 3717: per_all_assignments_f paf1

3713: cursor c_get_cnt_sd is
3714: select distinct pcnt.state_code || '-'|| pcnt.school_district_code,
3715: pcnt.county_code
3716: from pay_us_emp_county_tax_rules_f pcnt,
3717: per_all_assignments_f paf1
3718: where paf1.person_id = l_person_id
3719: and paf1.effective_end_date >= l_year_start
3720: and paf1.effective_start_date <= l_year_end
3721: and paf1.assignment_id = pcnt.assignment_id

Line 3731: per_all_assignments_f paf1

3727: select distinct pcty.state_code || '-'|| pcty.school_district_code,
3728: county_code,
3729: city_code
3730: from pay_us_emp_city_tax_rules_f pcty,
3731: per_all_assignments_f paf1
3732: where paf1.person_id = l_person_id
3733: and paf1.effective_end_date >= l_year_start
3734: and paf1.effective_start_date <= l_year_end
3735: and pcty.assignment_id = paf1.assignment_id

Line 3748: per_all_assignments_f paf,

3744: CURSOR c_get_latest_asg(p_person_id number ) IS
3745: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
3746: ||lpad(paa.assignment_action_id,15,'0')),16))
3747: from pay_assignment_actions paa,
3748: per_all_assignments_f paf,
3749: pay_payroll_actions ppa,
3750: pay_action_classifications pac
3751: where paf.person_id = p_person_id
3752: and paa.assignment_id = paf.assignment_id

Line 3798: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck

3794: and information_type= 'PAY_US_PENSION_REPORTING';
3795:
3796: CURSOR c_get_disability_plan_scl_info(cp_assignment_id in number , cp_tax_unit_id in number) IS
3797: select hsck.segment19
3798: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck
3799: where assignment_id = cp_assignment_id and
3800: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3801: hsck.segment1 = to_char(cp_tax_unit_id) and
3802: paf.effective_end_date = (select max(effective_end_date)

Line 3803: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1

3799: where assignment_id = cp_assignment_id and
3800: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3801: hsck.segment1 = to_char(cp_tax_unit_id) and
3802: paf.effective_end_date = (select max(effective_end_date)
3803: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1
3804: where paf1.assignment_id = paf.assignment_id and
3805: paf1.soft_coding_keyflex_id = hsck1.soft_coding_keyflex_id and
3806: hsck1.segment1 = hsck.segment1);
3807:

Line 3811: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck

3807:
3808: /* Bug # 8251746 */
3809: CURSOR c_get_flipp_scl_info(cp_assignment_id in number , cp_tax_unit_id in number) IS
3810: select hsck.segment20
3811: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck
3812: where assignment_id = cp_assignment_id and
3813: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3814: hsck.segment1 = to_char(cp_tax_unit_id) and
3815: paf.effective_end_date = (select max(effective_end_date)

Line 3816: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1

3812: where assignment_id = cp_assignment_id and
3813: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3814: hsck.segment1 = to_char(cp_tax_unit_id) and
3815: paf.effective_end_date = (select max(effective_end_date)
3816: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1
3817: where paf1.assignment_id = paf.assignment_id and
3818: paf1.soft_coding_keyflex_id = hsck1.soft_coding_keyflex_id and
3819: hsck1.segment1 = hsck.segment1);
3820:

Line 3839: , per_all_assignments_f ASS

3835: ,cp_ele_info1 IN VARCHAR2) IS
3836: SELECT TARGET.result_value
3837: FROM pay_assignment_actions BAL_ASSACT
3838: , pay_payroll_actions BACT
3839: , per_all_assignments_f ASS
3840: , pay_assignment_actions ASSACT
3841: , pay_payroll_actions PACT
3842: , pay_run_results RR
3843: , pay_run_result_values TARGET

Line 3870: and ASS.person_id = (select person_id from per_all_assignments_f START_ASS

3866: and PACT.effective_date between petf.effective_start_date
3867: and petf.effective_end_date
3868: and RR.status in ('P','PA')
3869: and ASSACT.assignment_id = ASS.assignment_id
3870: and ASS.person_id = (select person_id from per_all_assignments_f START_ASS
3871: where START_ASS.assignment_id = BAL_ASSACT.assignment_id
3872: and rownum = 1)
3873: and PACT.effective_date between ASS.effective_start_date
3874: and ASS.effective_end_date;

Line 3893: per_all_Assignments_f paf

3889: cursor c_get_jurisdiction (cp_person_id number
3890: ,cp_tax_unit_id number) is
3891: select distinct puar.jurisdiction_code
3892: from pay_us_asg_reporting puar,
3893: per_all_Assignments_f paf
3894: where puar.assignment_id = paf.assignment_id
3895: and paf.person_id = cp_person_id
3896: and puar.tax_unit_id = cp_tax_unit_id
3897: and length(puar.jurisdiction_code)=16

Line 5320: FROM per_all_assignments_f ASG,

5316: l_step := 1;
5317: hr_utility.trace('In eoy_range_cursor');
5318:
5319: eoy_gre_range := 'SELECT distinct ASG.person_id
5320: FROM per_all_assignments_f ASG,
5321: pay_us_asg_reporting puar,
5322: pay_payroll_actions PPA
5323: WHERE PPA.payroll_action_id = :payroll_action_id
5324: AND puar.tax_unit_id = substr(legislative_parameters,