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

Line 426: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)

422: AND legislation_code = 'AU'
423: AND c_year_end BETWEEN effective_start_date
424: AND effective_end_date;
425:
426: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
427: IS
428: SELECT to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
429: ,ppa.business_group_id
430: FROM pay_payroll_actions ppa

Line 664: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)

660:
661: ----------------------------------------------+
662: -- cursor to get the archive parameters
663: ----------------------------------------------+
664: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
665: is
666: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
667: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
668: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start

Line 1153: function get_max_effective_asg_date(p_asg_id per_all_assignments_f .assignment_id%type)

1149: close c_effective_date ;
1150: return l_effective_date ;
1151: end;
1152:
1153: function get_max_effective_asg_date(p_asg_id per_all_assignments_f .assignment_id%type)
1154: return date
1155: is
1156: l_effective_date date ;
1157: cursor c_effective_date

Line 1160: from per_all_assignments_f p

1156: l_effective_date date ;
1157: cursor c_effective_date
1158: is
1159: select max(effective_start_date)
1160: from per_all_assignments_f p
1161: where assignment_id =p_asg_id ;
1162: begin
1163: open c_effective_date;
1164: fetch c_effective_date into l_effective_date ;

Line 1745: FROM per_all_assignments_f paa

1741: SELECT /*+ ORDERED */ pee.element_entry_id element_entry_id,
1742: ppa.date_earned date_earned,
1743: pee.assignment_id assignment_id,
1744: pac.tax_unit_id /* Added for bug #5846278 */
1745: FROM per_all_assignments_f paa
1746: ,per_periods_of_service pps
1747: ,pay_assignment_actions pac
1748: ,pay_payroll_actions ppa
1749: ,pay_element_entries_f pee

Line 2072: , per_all_assignments_f paa

2068: ( select distinct nvl(pbt.reporting_name,pbt.balance_name) balance_name
2069: , pdb.defined_balance_id def_id
2070: , pbt.balance_type_id bal_type_id
2071: from pay_element_types_f pet
2072: , per_all_assignments_f paa
2073: , pay_balance_types pbt
2074: , pay_defined_balances pdb
2075: --, pay_balance_dimensions pbd
2076: --, per_periods_of_service pps

Line 2249: p_assignment_id per_all_Assignments_f.assignment_id%type ,

2245:
2246: procedure archive_etp_payment_details
2247: ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2248: p_registered_employer NUMBER, --2610141
2249: p_assignment_id per_all_Assignments_f.assignment_id%type ,
2250: p_year_start date,
2251: p_year_end date ) as
2252:
2253:

Line 2254: cursor etp_paid(c_assignment_id per_all_Assignments_f.assignment_id%type,

2250: p_year_start date,
2251: p_year_end date ) as
2252:
2253:
2254: cursor etp_paid(c_assignment_id per_all_Assignments_f.assignment_id%type,
2255: c_year_start date ,
2256: c_year_end date ) is
2257:
2258: select prv.result_value

Line 2264: ,per_all_assignments_f paa

2260: ,pac.assignment_action_id
2261: ,ppa.effective_date
2262: from pay_element_types_f pet
2263: ,pay_input_values_f piv
2264: ,per_all_assignments_f paa
2265: ,pay_run_results prr
2266: ,pay_run_result_values prv
2267: ,pay_assignment_actions pac
2268: ,pay_payroll_actions ppa

Line 2321: (c_assignment_id per_all_assignments_f.assignment_id%type,

2317:
2318: /* Bug No: 3603495 - Performance Fix - Modified the following cursor by introducing per_assignments_f table and its joins */
2319:
2320: cursor etp_BA_or_BI
2321: (c_assignment_id per_all_assignments_f.assignment_id%type,
2322: c_year_start date ,
2323: c_year_end date )
2324: is select max(ppa.payroll_action_id) payroll_action_id
2325: ,max(pac.assignment_action_id) assignment_action_id

Line 2440: , per_all_assignments_f paa

2436: , pay_balance_pkg.get_value(pdb.defined_balance_id, p_max_assignment_action_id, p_registered_employer,null,null,null,null) balance_value
2437: , pdb.defined_balance_id def_id
2438: , pbt.balance_type_id bal_type_id
2439: from pay_element_types_f pet
2440: , per_all_assignments_f paa
2441: , pay_balance_types pbt
2442: , pay_defined_balances pdb
2443: , pay_payroll_actions ppa
2444: , pay_assignment_actions pac

Line 2671: , per_all_assignments_f paa

2667: , pay_element_entries_f pee
2668: , pay_element_links_f pel
2669: , per_all_people_f pap
2670: , per_periods_of_service pps
2671: , per_all_assignments_f paa
2672: where pet.element_type_id = piv.element_type_id
2673: and pbf.input_value_id = piv.input_value_id
2674: and pbf.balance_type_id = pbt.balance_type_id
2675: and pet.element_type_id = pel.element_type_id

Line 2897: per_all_assignments_f paa,

2893: pay_input_values_f piv,
2894: pay_element_links_f pel,
2895: pay_element_entries_f pee,
2896: pay_element_entry_values_f pev,
2897: per_all_assignments_f paa,
2898: per_all_people_f pap,
2899: per_addresses pad,
2900: fnd_territories_tl fta,
2901: per_periods_of_service pps,

Line 2953: cursor etp_trans_paid_flags(c_assignment_id per_all_Assignments_f.assignment_id%type,

2949:
2950: --------------------------------------------------------------------------------------------------------------------------+
2951: -- Bug 5956223 cursor to fetch input values Transitional ETP and Part of Previously Paid ETP of Element ETP on Termination
2952: --------------------------------------------------------------------------------------------------------------------------+
2953: cursor etp_trans_paid_flags(c_assignment_id per_all_Assignments_f.assignment_id%type,
2954: c_year_start date ,
2955: c_year_end date ) IS
2956: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
2957: from pay_element_types_f pet

Line 2959: ,per_all_assignments_f paa

2955: c_year_end date ) IS
2956: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
2957: from pay_element_types_f pet
2958: ,pay_input_values_f piv
2959: ,per_all_assignments_f paa
2960: ,pay_run_results prr
2961: ,pay_run_result_values prv
2962: ,pay_assignment_actions pac
2963: ,pay_payroll_actions ppa

Line 3868: per_all_assignments_f paa,

3864: from hr_organization_information hoi,
3865: hr_organization_units hou,
3866: hr_soft_coding_keyflex hsc,
3867: hr_locations hlc, /* Bug No : 2263587 */
3868: per_all_assignments_f paa,
3869: per_all_assignments_f paaf, /* Bug : 2610141 */
3870: per_all_people_f pap,
3871: per_addresses pad,
3872: fnd_territories_tl fta,

Line 3869: per_all_assignments_f paaf, /* Bug : 2610141 */

3865: hr_organization_units hou,
3866: hr_soft_coding_keyflex hsc,
3867: hr_locations hlc, /* Bug No : 2263587 */
3868: per_all_assignments_f paa,
3869: per_all_assignments_f paaf, /* Bug : 2610141 */
3870: per_all_people_f pap,
3871: per_addresses pad,
3872: fnd_territories_tl fta,
3873: per_periods_of_service pps,

Line 3913: from per_all_assignments_f a

3909: and ppa2.effective_date between add_months(p_year_start,-3) and p_year_end )/*Bug3048962 */
3910: /* End of Bug# 2448441 */
3911: and (paa.effective_start_date, paaf.effective_start_date)
3912: = (select max(a.effective_Start_date),min(a.effective_start_date) -- Bug 2610141
3913: from per_all_assignments_f a
3914: , hr_soft_coding_keyflex hsc1 --Added for bug 4177679
3915: where a.assignment_id = paa.assignment_id
3916: and hsc1.soft_coding_keyflex_id = a.soft_coding_keyflex_id --Added for bug 4177679
3917: and hsc1.segment1= p_registered_employer --Added for bug 4177679

Line 3933: FROM per_all_assignments_f paaf,

3929: where assignment has payroll attached to it for few months but is not attached at the end of year*/
3930: CURSOR c_get_payroll_name
3931: IS
3932: SELECT pay.payroll_name
3933: FROM per_all_assignments_f paaf,
3934: pay_payrolls_f pay
3935: WHERE paaf.assignment_id = p_assignment_id
3936: and paaf.effective_end_date = (select max(effective_end_date)
3937: From per_assignments_f iipaf

Line 4639: per_all_assignments_f a,

4635: pps.pds_information2,
4636: to_number(substr(max(lpad(ppa.action_sequence,15,'0')||ppa.assignment_action_id),16)), --3755305
4637: pps.final_process_date final_process_date --3263659
4638: from per_all_people_f p,
4639: per_all_assignments_f a,
4640: per_periods_of_service pps,
4641: pay_all_payrolls_f papf, --4281290
4642: pay_payroll_actions pa,
4643: pay_assignment_actions ppa

Line 4670: from per_all_assignments_f aa

4666: where p.person_id = pp.person_id
4667: and p.business_group_id = c_business_group_id
4668: ) -- Bug 2856638
4669: and a.effective_start_date = (select max(aa.effective_start_date)
4670: from per_all_assignments_f aa
4671: where aa.assignment_id = c_assignment_id
4672: ) --4281290
4673: and pa.action_type in ('R','Q','I','B','V') --2646912, 4063321
4674: and a.period_of_service_id = pps.period_of_service_id --3586388

Line 4711: (c_assignment_id per_all_assignments_f.assignment_id%TYPE

4707: -- Cursor to get maximum assignment_action_id to use in BBR Call (Bug 4738470)
4708: ----------------------------------------------------------------------------------------+
4709: --
4710: cursor c_max_asg_action_id
4711: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
4712: ,c_business_group_id hr_all_organization_units.organization_id%TYPE
4713: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE
4714: ,c_year_start date
4715: ,c_year_end date