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 603: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)

599: AND legislation_code = 'AU'
600: AND c_year_end BETWEEN effective_start_date
601: AND effective_end_date;
602:
603: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
604: IS
605: SELECT to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
606: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters) registered_employer /*bug9147430*/
607: ,ppa.business_group_id

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

1143:
1144: ----------------------------------------------+
1145: -- cursor to get the archive parameters
1146: ----------------------------------------------+
1147: cursor get_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
1148: is
1149: select to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
1150: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
1151: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start

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

2013: close c_effective_date ;
2014: return l_effective_date ;
2015: end;
2016:
2017: function get_max_effective_asg_date(p_asg_id per_all_assignments_f .assignment_id%type)
2018: return date
2019: is
2020: l_effective_date date ;
2021: cursor c_effective_date

Line 2024: from per_all_assignments_f p

2020: l_effective_date date ;
2021: cursor c_effective_date
2022: is
2023: select max(effective_start_date)
2024: from per_all_assignments_f p
2025: where assignment_id =p_asg_id ;
2026: begin
2027: open c_effective_date;
2028: fetch c_effective_date into l_effective_date ;

Line 2716: FROM per_all_assignments_f paa

2712: ppa.date_earned date_earned,
2713: pee.assignment_id assignment_id,
2714: pac.tax_unit_id, /* Added for bug #5846278 */
2715: pdb.balance_type_id
2716: FROM per_all_assignments_f paa
2717: ,per_periods_of_service pps
2718: ,pay_assignment_actions pac
2719: ,pay_payroll_actions ppa
2720: ,pay_element_entries_f pee

Line 3314: , per_all_assignments_f paa

3310: , pay_element_entries_f pee
3311: , pay_element_links_f pel
3312: , per_all_people_f pap
3313: , per_periods_of_service pps
3314: , per_all_assignments_f paa
3315: where pet.element_type_id = piv.element_type_id
3316: and pbf.input_value_id = piv.input_value_id
3317: and pbf.balance_type_id = pbt.balance_type_id
3318: and pet.element_type_id = pel.element_type_id

Line 4428: p_assignment_id per_all_Assignments_f.assignment_id%type ,

4424:
4425: procedure archive_etp_payment_details
4426: ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type,
4427: p_registered_employer NUMBER, --2610141
4428: p_assignment_id per_all_Assignments_f.assignment_id%type ,
4429: p_year_start date,
4430: p_year_end date ) as
4431:
4432:

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

4429: p_year_start date,
4430: p_year_end date ) as
4431:
4432:
4433: cursor etp_paid(c_assignment_id per_all_Assignments_f.assignment_id%type,
4434: c_year_start date ,
4435: c_year_end date ) is
4436:
4437: select prv.result_value

Line 4443: ,per_all_assignments_f paa

4439: ,pac.assignment_action_id
4440: ,ppa.effective_date
4441: from pay_element_types_f pet
4442: ,pay_input_values_f piv
4443: ,per_all_assignments_f paa
4444: ,pay_run_results prr
4445: ,pay_run_result_values prv
4446: ,pay_assignment_actions pac
4447: ,pay_payroll_actions ppa

Line 4500: (c_assignment_id per_all_assignments_f.assignment_id%type,

4496:
4497: /* Bug No: 3603495 - Performance Fix - Modified the following cursor by introducing per_assignments_f table and its joins */
4498:
4499: cursor etp_BA_or_BI
4500: (c_assignment_id per_all_assignments_f.assignment_id%type,
4501: c_year_start date ,
4502: c_year_end date )
4503: is select max(ppa.payroll_action_id) payroll_action_id
4504: ,max(pac.assignment_action_id) assignment_action_id

Line 4531: (c_assignment_id per_all_assignments_f.assignment_id%type,

4527: l_etp_paid_date varchar2(20);
4528:
4529: -- Bug# 12584258 for handling NULL value in ETP_Payment_Date -- START
4530: cursor act_term_date
4531: (c_assignment_id per_all_assignments_f.assignment_id%type,
4532: c_year_start date ,
4533: c_year_end date )
4534: is select to_char(pps.actual_termination_date,'DDMMYYYY')
4535: from per_all_assignments_f paa,

Line 4535: from per_all_assignments_f paa,

4531: (c_assignment_id per_all_assignments_f.assignment_id%type,
4532: c_year_start date ,
4533: c_year_end date )
4534: is select to_char(pps.actual_termination_date,'DDMMYYYY')
4535: from per_all_assignments_f paa,
4536: per_periods_of_service pps
4537: where paa.person_id = pps.person_id
4538: and paa.period_of_service_id = pps.period_of_service_id
4539: and paa.assignment_id = c_assignment_id

Line 4648: , per_all_assignments_f paa

4644: , pay_balance_pkg.get_value(pdb.defined_balance_id, p_max_assignment_action_id, p_registered_employer,null,null,null,null) balance_value
4645: , pdb.defined_balance_id def_id
4646: , pbt.balance_type_id bal_type_id
4647: from pay_element_types_f pet
4648: , per_all_assignments_f paa
4649: , pay_balance_types pbt
4650: , pay_defined_balances pdb
4651: , pay_payroll_actions ppa
4652: , pay_assignment_actions pac

Line 4943: , per_all_assignments_f paa

4939: , pay_element_entries_f pee
4940: , pay_element_links_f pel
4941: , per_all_people_f pap
4942: , per_periods_of_service pps
4943: , per_all_assignments_f paa
4944: where pet.element_type_id = piv.element_type_id
4945: and pbf.input_value_id = piv.input_value_id
4946: and pbf.balance_type_id = pbt.balance_type_id
4947: and pet.element_type_id = pel.element_type_id

Line 5177: per_all_assignments_f paa,

5173: pay_input_values_f piv,
5174: pay_element_links_f pel,
5175: pay_element_entries_f pee,
5176: pay_element_entry_values_f pev,
5177: per_all_assignments_f paa,
5178: per_all_people_f pap,
5179: per_addresses pad,
5180: fnd_territories_tl fta,
5181: per_periods_of_service pps,

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

5230:
5231: --------------------------------------------------------------------------------------------------------------------------+
5232: -- Bug 5956223 cursor to fetch input values Transitional ETP and Part of Previously Paid ETP of Element ETP on Termination
5233: --------------------------------------------------------------------------------------------------------------------------+
5234: cursor etp_trans_paid_flags(c_assignment_id per_all_Assignments_f.assignment_id%type,
5235: c_year_start date ,
5236: c_year_end date ) IS
5237: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
5238: from pay_element_types_f pet

Line 5240: ,per_all_assignments_f paa

5236: c_year_end date ) IS
5237: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
5238: from pay_element_types_f pet
5239: ,pay_input_values_f piv
5240: ,per_all_assignments_f paa
5241: ,pay_run_results prr
5242: ,pay_run_result_values prv
5243: ,pay_assignment_actions pac
5244: ,pay_payroll_actions ppa

Line 5997: ,per_all_assignments_f paaf

5993: ,to_char(ppa.effective_date,'DDMMYYYY') run_effective_date
5994: ,pac.assignment_action_id
5995: ,ppa.payroll_action_id
5996: FROM pay_run_results prr
5997: ,per_all_assignments_f paaf
5998: ,pay_assignment_actions pac
5999: ,pay_payroll_actions ppa
6000: ,pay_payrolls_f papf
6001: ,pay_element_types_f pet

Line 7313: per_all_assignments_f paa,

7309: from hr_organization_information hoi,
7310: hr_organization_units hou,
7311: hr_soft_coding_keyflex hsc,
7312: hr_locations hlc, /* Bug No : 2263587 */
7313: per_all_assignments_f paa,
7314: per_all_assignments_f paaf, /* Bug : 2610141 */
7315: per_all_people_f pap,
7316: per_addresses pad,
7317: fnd_territories_tl fta,

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

7310: hr_organization_units hou,
7311: hr_soft_coding_keyflex hsc,
7312: hr_locations hlc, /* Bug No : 2263587 */
7313: per_all_assignments_f paa,
7314: per_all_assignments_f paaf, /* Bug : 2610141 */
7315: per_all_people_f pap,
7316: per_addresses pad,
7317: fnd_territories_tl fta,
7318: per_periods_of_service pps,

Line 7358: from per_all_assignments_f a

7354: and ppa2.effective_date between add_months(p_year_start,-3) and p_year_end )/*Bug3048962 */
7355: /* End of Bug# 2448441 */
7356: and (paa.effective_start_date, paaf.effective_start_date)
7357: = (select max(a.effective_Start_date),min(a.effective_start_date) -- Bug 2610141
7358: from per_all_assignments_f a
7359: , hr_soft_coding_keyflex hsc1 --Added for bug 4177679
7360: where a.assignment_id = paa.assignment_id
7361: and hsc1.soft_coding_keyflex_id = a.soft_coding_keyflex_id --Added for bug 4177679
7362: and hsc1.segment1= p_registered_employer --Added for bug 4177679

Line 7378: FROM per_all_assignments_f paaf,

7374: where assignment has payroll attached to it for few months but is not attached at the end of year*/
7375: CURSOR c_get_payroll_name
7376: IS
7377: SELECT pay.payroll_name
7378: FROM per_all_assignments_f paaf,
7379: pay_payrolls_f pay
7380: WHERE paaf.assignment_id = p_assignment_id
7381: and paaf.effective_end_date = (select max(effective_end_date)
7382: From per_assignments_f iipaf

Line 8104: per_all_assignments_f a,

8100: pps.pds_information2,
8101: to_number(substr(max(lpad(ppa.action_sequence,15,'0')||ppa.assignment_action_id),16)), --3755305
8102: pps.final_process_date final_process_date --3263659
8103: from per_all_people_f p,
8104: per_all_assignments_f a,
8105: per_periods_of_service pps,
8106: pay_all_payrolls_f papf, --4281290
8107: pay_payroll_actions pa,
8108: pay_assignment_actions ppa

Line 8139: from per_all_assignments_f aa

8135: where p.person_id = pp.person_id
8136: and p.business_group_id = c_business_group_id
8137: ) -- Bug 2856638
8138: and a.effective_start_date = (select max(aa.effective_start_date)
8139: from per_all_assignments_f aa
8140: where aa.assignment_id = c_assignment_id
8141: ) --4281290
8142: and pa.action_type in ('R','Q','I','B','V') --2646912, 4063321
8143: and a.period_of_service_id = pps.period_of_service_id --3586388

Line 8181: (c_assignment_id per_all_assignments_f.assignment_id%TYPE

8177: -- Cursor to get maximum assignment_action_id to use in BBR Call (Bug 4738470)
8178: ----------------------------------------------------------------------------------------+
8179: --
8180: cursor c_max_asg_action_id
8181: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
8182: ,c_business_group_id hr_all_organization_units.organization_id%TYPE
8183: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE
8184: ,c_year_start date
8185: ,c_year_end date

Line 8270: (c_assignment_id per_all_assignments_f.assignment_id%TYPE

8266:
8267: /* Bug 9872891 - Added new cursor to get effective date when ETP payments
8268: have been made for previously terminated employees */
8269: CURSOR c_etp_max_pay_date
8270: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
8271: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE
8272: ,c_year_start DATE
8273: ,c_year_end DATE
8274: ) is

Line 9646: FROM per_all_assignments_f paa

9642: prv.result_value,
9643: ppa.date_earned date_earned,
9644: ppa.effective_date,
9645: pec.classification_name
9646: FROM per_all_assignments_f paa
9647: ,per_periods_of_service pps
9648: ,pay_assignment_actions pac
9649: ,pay_payroll_actions ppa
9650: ,pay_element_entries_f pee

Line 9687: from per_all_assignments_f paa

9683:
9684:
9685: cursor csr_get_fw_status_exist (c_date date) is
9686: select 'Y'
9687: from per_all_assignments_f paa
9688: ,per_time_periods ptp
9689: ,per_assignment_status_types past
9690: where paa.assignment_id = p_assignment_id
9691: and paa.payroll_id = ptp.payroll_id