DBA Data[Home] [Help]

APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on PAY_US_ASG_REPORTING

Line 922: pay_us_asg_reporting puar

918: is
919: select distinct has.assignment_id
920: from hr_assignment_set_amendments has,
921: per_assignments_f paf,
922: pay_us_asg_reporting puar
923: where has.assignment_set_id = cp_assignment_set_id
924: and paf.assignment_id = has.assignment_id
925: and nvl(has.include_or_exclude,'I') = 'I'
926: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1

Line 1037: pay_us_asg_reporting puar

1033: is
1034: select distinct has.assignment_id
1035: from hr_assignment_set_amendments has,
1036: per_assignments_f paf,
1037: pay_us_asg_reporting puar
1038: where assignment_set_id = cp_assignment_set_id
1039: and paf.assignment_id = has.assignment_id
1040: and nvl(has.include_or_exclude,'I') = 'I'
1041: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1

Line 1136: pay_us_asg_reporting puar

1132: is
1133: select distinct has.assignment_id, puar.tax_unit_id
1134: from hr_assignment_set_amendments has,
1135: per_assignments_f paf,
1136: pay_us_asg_reporting puar
1137: where assignment_set_id = cp_assignment_set_id
1138: and paf.assignment_id = has.assignment_id
1139: and nvl(has.include_or_exclude,'I') = 'I'
1140: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1

Line 1153: l_gre_id pay_us_asg_reporting.tax_unit_id%type;

1149: from hr_organization_units
1150: where organization_id = cp_gre_id;
1151:
1152: l_oth_assignment_id per_assignments_f.assignment_id%type;
1153: l_gre_id pay_us_asg_reporting.tax_unit_id%type;
1154: l_header_printed varchar2(1) := 'N';
1155:
1156: BEGIN
1157: