DBA Data[Home] [Help]

APPS.PAY_CORE_UTILS dependencies on PER_TIME_PERIODS

Line 420: from per_time_periods ptp,

416: begin
417: --
418: select ptp.start_date
419: into l_start_date
420: from per_time_periods ptp,
421: pay_payroll_actions ppa
422: where ppa.payroll_action_id = p_payroll_action_id
423: and ppa.payroll_id = ptp.payroll_id
424: and ppa.date_earned between ptp.start_date

Line 580: per_time_periods ptp,

576: l_prd_start_date,
577: l_prorate_grp_id
578: from pay_payroll_actions ppa,
579: pay_assignment_actions paa,
580: per_time_periods ptp,
581: pay_element_types_f pet
582: where paa.assignment_action_id = p_asg_act_id
583: and paa.payroll_action_id = ppa.payroll_action_id
584: and pet.element_type_id = p_et_id