APPS.PAY_AU_EXC dependencies on PAY_PAYROLL_ACTIONS

Line 55: pay_payroll_actions pact

51: having the payroll action id */
52: SELECT PTP.end_date+1
53: INTO l_next_to_end_date
54: FROM per_time_periods ptp,
55: pay_payroll_actions pact
56: WHERE pact.payroll_action_id = p_payroll_action_id
57: AND pact.payroll_id = ptp.payroll_id
58: AND p_given_date between ptp.start_date and ptp.end_date;
59:

Line 196: from pay_payroll_actions act

192: ( p_payroll_action_id number
193: , p_assignment_action_id number
194: , p_effective_date date) is
195: select ptp.time_period_id
196: from pay_payroll_actions act
197: , per_time_periods ptp
198: where payroll_action_id = p_payroll_action_id
199: and act.date_earned between ptp.start_date and ptp.end_date
200: and act.payroll_id = ptp.payroll_id

Line 248: l_business_group_id pay_payroll_actions.business_group_id%type;

244: l_date_dd_mm varchar2(11);
245: l_fy_user_span_start date;
246: l_frequency number;
247: l_dimension_name pay_balance_dimensions.dimension_name%type;
248: l_business_group_id pay_payroll_actions.business_group_id%type;
249: --
250: begin
251: hr_utility.set_location('Entering: asg_span_ec', 1);
252: l_dimension_name := upper(p_dimension_name);

Line 370: FROM pay_payroll_actions PACT,

366: l_user_le_start_date date;
367: cursor get_beg_of_fiscal_year(c_owner_payroll_action_id number)
368: is
369: SELECT fnd_date.canonical_to_date(org_information11)
370: FROM pay_payroll_actions PACT,
371: hr_organization_information HOI
372: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
373: AND HOI.organization_id = PACT.business_group_id
374: AND PACT.payroll_action_id = c_owner_payroll_action_id;