DBA Data[Home] [Help]

APPS.PAY_PAYRG_PKG dependencies on HR_ASSIGNMENT_SET

Line 321: HR_ASSIGNMENT_SET_AMENDMENTS HASA ,

317: ppa.effective_date,
318: act.source_action_id,
319: nvl(ppa.start_date,ppa.effective_date)
320: from
321: HR_ASSIGNMENT_SET_AMENDMENTS HASA ,
322: PER_ASSIGNMENTS_F PAF ,
323: PAY_ASSIGNMENT_ACTIONS ACT ,
324: PAY_PAYROLL_ACTIONS PPA ,
325: PAY_PAYROLLS_F PPF

Line 553: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;

549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
550: l_person_id per_all_assignments_f.person_id%TYPE;
551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
552: l_organization_id per_all_assignments_f.organization_id%TYPE;
553: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
554: cp_start_date pay_payroll_actions.effective_date%TYPE;
555: cp_effective_date pay_payroll_actions.effective_date%TYPE;
556:
557: l_run_eff_date date;

Line 676: l_asg_flag := hr_assignment_set.assignment_in_set(l_asg_set_id, assignid);

672: l_asg_flag := 'N';
673: l_action_insert := 'N';
674:
675: if l_asg_set_id is not null then
676: l_asg_flag := hr_assignment_set.assignment_in_set(l_asg_set_id, assignid);
677: else -- l_asg_set_id is null
678: l_asg_flag := 'Y';
679: end if;
680: