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_ZA_EOY_VAL dependencies on PER_TIME_PERIODS

Line 407: from per_time_periods

403: begin
404:
405: select to_char(min(start_date),'dd-mon-yyyy'),to_char(max(end_date),'dd-mon-yyyy')
406: into p_tax_start_date,p_tax_end_date
407: from per_time_periods
408: where payroll_id = p_payroll_id
409: and prd_information1 = p_tax_year;
410:
411: exception

Line 841: , per_time_periods PPTP

837: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
838: from pay_balance_feeds_f FEED
839: , pay_run_result_values TARGET
840: , pay_run_results RR
841: , per_time_periods PPTP
842: , per_time_periods BPTP
843: , pay_payroll_actions PACT
844: , pay_assignment_actions ASSACT
845: , pay_payroll_actions BACT

Line 842: , per_time_periods BPTP

838: from pay_balance_feeds_f FEED
839: , pay_run_result_values TARGET
840: , pay_run_results RR
841: , per_time_periods PPTP
842: , per_time_periods BPTP
843: , pay_payroll_actions PACT
844: , pay_assignment_actions ASSACT
845: , pay_payroll_actions BACT
846: , pay_assignment_actions BAL_ASSACT

Line 3257: per_time_periods ptp

3253: )
3254: and exists (select 1
3255: from pay_payroll_actions ppa,
3256: pay_assignment_actions paa,
3257: per_time_periods ptp
3258: where
3259: ppa.payroll_id=ass.payroll_id
3260: and paa.assignment_id=ass.assignment_id
3261: and ptp.payroll_id = ppa.payroll_id

Line 3767: from per_time_periods ptp2

3763: select distinct payroll_id
3764: from pay_all_payrolls_f papf
3765: where business_group_id = P_BUSINESS_GROUP_ID
3766: and exists ( select ''
3767: from per_time_periods ptp2
3768: where ptp2.prd_information1=l_tax_year
3769: and ptp2.payroll_id = papf.payroll_id
3770: );
3771: */

Line 3949: from per_time_periods ptp

3945: AND asgn2.effective_start_date =
3946: ( select max(paf2.effective_start_date)
3947: from per_assignments_f paf2
3948: where paf2.effective_start_date <= ( select max(ptp.end_date)
3949: from per_time_periods ptp
3950: where ptp.prd_information1 = p_tax_year
3951: and ptp.payroll_id = asgn2.payroll_id)
3952: and paf2.assignment_id = asgn2.assignment_id
3953: )

Line 4148: , per_time_periods PPTP

4144: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
4145: from pay_balance_feeds_f FEED
4146: , pay_run_result_values TARGET
4147: , pay_run_results RR
4148: , per_time_periods PPTP
4149: , per_time_periods BPTP
4150: , pay_payroll_actions PACT
4151: , pay_assignment_actions ASSACT
4152: , pay_payroll_actions BACT

Line 4149: , per_time_periods BPTP

4145: from pay_balance_feeds_f FEED
4146: , pay_run_result_values TARGET
4147: , pay_run_results RR
4148: , per_time_periods PPTP
4149: , per_time_periods BPTP
4150: , pay_payroll_actions PACT
4151: , pay_assignment_actions ASSACT
4152: , pay_payroll_actions BACT
4153: , pay_assignment_actions BAL_ASSACT

Line 4746: per_time_periods ptp

4742: select max(paa.action_sequence)
4743: into l_run_action_seq
4744: from pay_assignment_actions paa,
4745: pay_payroll_actions ppa,
4746: per_time_periods ptp
4747: where paa.assignment_id = rec_asgn.assignment_id
4748: and paa.action_status IN ('C','S') -- 10376999
4749: and paa.payroll_action_id = ppa.payroll_action_id
4750: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')