APPS.PAY_BALANCE_PKG dependencies on PER_TIME_PERIODS

Line 531: from per_time_periods

527: elsif (p_period_type = 'PERIOD') then
528: --
529: select start_date
530: into l_return_date
531: from per_time_periods
532: where payroll_id = p_payroll_id
533: and p_effective_date between start_date
534: and end_date;
535: --

Line 698: from per_time_periods

694: elsif (p_period_type = 'PERIOD') then
695: --
696: select end_date
697: into l_return_date
698: from per_time_periods
699: where payroll_id = p_payroll_id
700: and p_effective_date between start_date
701: and end_date;
702: --

Line 5825: l_time_period_id per_time_periods.time_period_id%type;

5821: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5822: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5823: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5824: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
5825: l_time_period_id per_time_periods.time_period_id%type;
5826: l_asg_lock boolean;
5827: --
5828: begin
5829: g_debug := hr_utility.debug_enabled;

Line 5874: from per_time_periods TIMEP

5870: hr_utility.set_location ('pay_balance_pkg.get_value', 12);
5871: end if;
5872: select TIMEP.time_period_id
5873: into l_time_period_id
5874: from per_time_periods TIMEP
5875: where TIMEP.payroll_id = l_payroll_id
5876: and p_virtual_date between TIMEP.start_date
5877: and TIMEP.end_date;
5878: exception

Line 7091: per_time_periods ptp,

7087: , prr.local_unit_id local_unit_id
7088: , ppa.effective_date
7089: from pay_assignment_actions paa,
7090: pay_payroll_actions ppa,
7091: per_time_periods ptp,
7092: pay_run_results prr
7093: where paa.assignment_action_id = p_asg_action
7094: and ppa.payroll_action_id = paa.payroll_action_id
7095: and paa.assignment_action_id = prr.assignment_action_id

Line 8082: per_time_periods ptp,

8078: , prr.time_definition_id
8079: , nvl(prr.end_date, ptp.end_date) balance_date
8080: from pay_assignment_actions paa,
8081: pay_payroll_actions ppa,
8082: per_time_periods ptp,
8083: pay_run_results prr
8084: where paa.assignment_action_id = asgact
8085: and paa.assignment_action_id = prr.assignment_action_id
8086: and ppa.payroll_action_id = paa.payroll_action_id

Line 8356: -- bug 9368185 avoid to per_time_periods for balance date context

8352: p_sn2_needed in varchar2,
8353: p_org_needed in varchar2,
8354: p_earned_period_end_date date) is
8355:
8356: -- bug 9368185 avoid to per_time_periods for balance date context
8357: select /*+ ORDERED USE_NL (prr) INDEX(prr pay_run_results_n50)*/
8358: distinct
8359: decode(p_tu_needed,
8360: 'Y', paa.tax_unit_id,

Line 8413: l_earned_period_end_date per_time_periods.end_date%type;

8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8411: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8412: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8413: l_earned_period_end_date per_time_periods.end_date%type;
8414: --
8415: begin
8416: --
8417: if g_debug then

Line 8460: from per_time_periods ptp, pay_payroll_actions ppa

8456: end if;
8457: if (l_defbal_rec.bd_needed = TRUE) then
8458: l_bd_needed_chr := 'Y';
8459: select ptp.end_date into l_earned_period_end_date
8460: from per_time_periods ptp, pay_payroll_actions ppa
8461: where ppa.payroll_action_id = p_pactid
8462: and ptp.payroll_id = ppa.payroll_id
8463: and ppa.date_earned between ptp.start_date and ptp.end_date;
8464: end if;

Line 8826: per_time_periods ptp,

8822: , nvl(prr.end_date, ptp.end_date) balance_date
8823: , prr.local_unit_id local_unit_id
8824: from pay_assignment_actions paa,
8825: pay_payroll_actions ppa,
8826: per_time_periods ptp,
8827: pay_run_results prr
8828: where paa.payroll_action_id = p_pact_id
8829: and paa.assignment_action_id = prr.assignment_action_id
8830: and ppa.payroll_action_id = paa.payroll_action_id

Line 9231: -- bug 9368185 join to per_time_periods only for balance date context

9227: p_lu_needed in varchar2,
9228: p_sn2_needed in varchar2,
9229: p_org_needed in varchar2,
9230: p_earned_period_end_date in date) is
9231: -- bug 9368185 join to per_time_periods only for balance date context
9232: select /*+ ORDERED USE_NL(prr) INDEX(prr pay_run_results_n50)*/
9233: distinct
9234: decode(p_tu_needed,
9235: 'Y', paa.tax_unit_id,

Line 9287: l_earned_period_end_date per_time_periods.end_date%type;

9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9285: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9286: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9287: l_earned_period_end_date per_time_periods.end_date%type;
9288: --
9289: begin
9290: --
9291: if g_debug then

Line 9335: per_time_periods ptp

9331: l_bd_needed_chr := 'Y';
9332: select ptp.end_date into l_earned_period_end_date
9333: from pay_assignment_actions paa,
9334: pay_payroll_actions ppa,
9335: per_time_periods ptp
9336: where paa.assignment_action_id = p_asgact_id
9337: and ppa.payroll_action_id = paa.payroll_action_id
9338: and ptp.payroll_id = ppa.payroll_id
9339: and ppa.date_earned between ptp.start_date and ptp.end_date;

Line 9731: per_time_periods ptp,

9727: , nvl(prr.end_date, ptp.end_date) balance_date
9728: , prr.local_unit_id
9729: from pay_assignment_actions paa,
9730: pay_payroll_actions ppa,
9731: per_time_periods ptp,
9732: pay_run_results prr
9733: where paa.assignment_action_id = asgact
9734: and paa.assignment_action_id = prr.assignment_action_id
9735: and ppa.payroll_action_id = paa.payroll_action_id

Line 10320: per_time_periods ptp

10316: , prr.local_unit_id
10317: from pay_assignment_actions paa,
10318: pay_run_results prr,
10319: pay_payroll_actions ppa,
10320: per_time_periods ptp
10321: where ppa.payroll_action_id = p_pact_id
10322: and paa.payroll_action_id = ppa.payroll_action_id
10323: and paa.assignment_action_id = prr.assignment_action_id
10324: and ptp.payroll_id = ppa.payroll_id