DBA Data[Home] [Help]

APPS.PAY_CORE_UTILS dependencies on PER_TIME_PERIODS

Line 512: from per_time_periods ptp,

508: begin
509: --
510: select ptp.start_date
511: into l_start_date
512: from per_time_periods ptp,
513: pay_payroll_actions ppa
514: where ppa.payroll_action_id = p_payroll_action_id
515: and ppa.payroll_id = ptp.payroll_id
516: and ppa.date_earned between ptp.start_date

Line 672: per_time_periods ptp,

668: l_prd_start_date,
669: l_prorate_grp_id
670: from pay_payroll_actions ppa,
671: pay_assignment_actions paa,
672: per_time_periods ptp,
673: pay_element_types_f pet
674: where paa.assignment_action_id = p_asg_act_id
675: and paa.payroll_action_id = ppa.payroll_action_id
676: and pet.element_type_id = p_et_id