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

Line 813: from per_time_periods PTP

809: and v.result_value <> '0'); --Added for bug 13054902
810:
811: cursor c_ptp (taxable_update_payroll number, c_date_paid date) is
812: select min(PTP.start_date) start_date
813: from per_time_periods PTP
814: where PTP.payroll_id = taxable_update_payroll
815: and (PTP.REGULAR_PAYMENT_DATE ) >= (/*start of fyear prior to session date*/
816: to_date('06-04-'||
817: to_char(fnd_number.canonical_to_number(to_char(c_date_paid,'YYYY'))

Line 955: FROM per_time_periods ptp, pay_assignment_actions act, pay_payroll_actions pact

951: SELECT to_date('06-04-'||
952: to_char(fnd_number.canonical_to_number(to_char(ptp.regular_payment_date,'YYYY'))
953: + least(sign(ptp.regular_payment_date - to_date('06-04-'
954: || to_char(ptp.regular_payment_date,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY')
955: FROM per_time_periods ptp, pay_assignment_actions act, pay_payroll_actions pact
956: WHERE act.assignment_action_id = p_asg_action_id
957: AND act.payroll_Action_id = pact.payroll_action_id
958: AND pact.time_period_id = ptp.time_period_id;
959: --

Line 2013: per_time_periods ptp

2009: select 1 from dual where exists
2010: (select paa.assignment_action_id
2011: from pay_assignment_actions paa,
2012: pay_payroll_actions ppa,
2013: per_time_periods ptp
2014: where ptp.time_period_id = ppa.time_period_id
2015: and ppa.payroll_action_id = paa.payroll_action_id
2016: and paa.assignment_id = c_assignment_id
2017: and ppa.action_type in ('R','Q','V','I','B')

Line 2021: per_time_periods ptp

2017: and ppa.action_type in ('R','Q','V','I','B')
2018: and ptp.regular_payment_date =
2019: (select max(ptp.regular_payment_date)
2020: from per_all_assignments_f paf,
2021: per_time_periods ptp
2022: where ptp.regular_payment_date <= c_last_process_date
2023: and paf.assignment_id = c_assignment_id
2024: and ptp.payroll_id = paf.payroll_id
2025: and c_effective_end_date between

Line 2290: per_time_periods ptp,

2286: FROM per_all_people_f p,
2287: per_all_assignments_f a,
2288: per_assignment_status_types past,
2289: pay_all_payrolls_f ppf,
2290: per_time_periods ptp,
2291: per_periods_of_service serv,
2292: hr_soft_coding_keyflex flex
2293: WHERE a.person_id BETWEEN stperson AND endperson
2294: AND a.business_group_id +0 = g_business_group_id

Line 2349: per_time_periods ptp,

2345: per_all_people_f p,
2346: per_all_assignments_f a,
2347: per_assignment_status_types past,
2348: pay_all_payrolls_f ppf,
2349: per_time_periods ptp,
2350: per_periods_of_service serv,
2351: hr_soft_coding_keyflex flex
2352: WHERE p.person_id = ppr.person_id
2353: AND ppr.chunk_number = chunk

Line 3160: l_period_no per_time_periods.period_num%TYPE;

3156: l_last_pay_action_id pay_assignment_actions.payroll_action_id%TYPE;
3157: --
3158: l_student_loan_flag VARCHAR2(1);
3159: --
3160: l_period_no per_time_periods.period_num%TYPE;
3161: l_tax_reference VARCHAR2(20);
3162: l_tax_code pay_element_entry_values_f.screen_entry_value%TYPE;
3163: l_tax_basis pay_element_entry_values_f.screen_entry_value%TYPE;
3164: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;

Line 3262: FROM per_time_periods ptp

3258: -- Bug 5478073: Get period number in which assignment was terminated
3259: CURSOR csr_get_term_period_no(p_term_date DATE, p_payroll_id NUMBER) IS
3260: --Bug 7281023: Changed cursor logic
3261: /*SELECT nvl(max(ptp.period_num),0) -- Max and nvl are added to return 0 if period not found
3262: FROM per_time_periods ptp
3263: WHERE ptp.payroll_id = p_payroll_id
3264: AND p_term_date BETWEEN ptp.start_date AND ptp.end_date;
3265: --*/
3266: --will fetch the period num of the first row ordered by regular_payment_date in ascending order

Line 3268: FROM per_time_periods

3264: AND p_term_date BETWEEN ptp.start_date AND ptp.end_date;
3265: --*/
3266: --will fetch the period num of the first row ordered by regular_payment_date in ascending order
3267: SELECT distinct first_value(period_num) Over(order by regular_payment_date)
3268: FROM per_time_periods
3269: Where payroll_id = p_payroll_id
3270: AND regular_payment_date >= p_term_date;
3271:
3272: --

Line 3275: FROM per_time_periods ptp,

3271:
3272: --
3273: cursor csr_period_number(p_payroll_action_id NUMBER) IS
3274: SELECT nvl(max(ptp.period_num),0) -- Max and nvl are added to return 0 if period not found
3275: FROM per_time_periods ptp,
3276: pay_payroll_actions pact
3277: WHERE pact.payroll_action_id = p_payroll_action_id
3278: AND ptp.payroll_id = pact.payroll_id
3279: AND pact.date_earned BETWEEN ptp.start_date AND ptp.end_date;

Line 4829: per_time_periods ptp -- moved to subquery to make sure latest payroll action having period num matching the archive is fetched

4825: (
4826: select to_number(substr(max(lpad(to_char(act.action_sequence), 20, '0')||to_char(pact.payroll_action_id)),21)) -- just to be consistent with rest of the code to get highest action based on the action sequence
4827: from pay_assignment_actions act,
4828: pay_payroll_actions pact,
4829: per_time_periods ptp -- moved to subquery to make sure latest payroll action having period num matching the archive is fetched
4830: where pact.payroll_action_id = act.payroll_action_id
4831: and pact.action_type in ('Q', 'R', 'B', 'I', 'V')
4832: and act.assignment_id = c_assignment_id
4833: and pact.action_sequence < c_action_sequence -- assuming you will write another sql to get p_p45_action_sequence, alternatively another join to pay_assignment_actions can get you this value in this sql