APPS.PAY_US_PSD_XML dependencies on PER_ASSIGNMENTS_F

Line 828: l_asg_id per_assignments_f.assignment_id%type;

824: p_business_group_id NUMBER,
825: p_tax_coll_dist_code VARCHAR2
826: )
827: RETURN BOOLEAN IS
828: l_asg_id per_assignments_f.assignment_id%type;
829: l_tax_unit_id hr_organization_information.organization_id%type;
830: l_psd_rules_exist varchar2(2);
831: l_psd_code varchar2(50);
832: l_psd_code_exsists varchar2(2);

Line 1501: l_assignment_id per_assignments_f.assignment_id%type;

1497:
1498: /* Variables used to hold the select columns from the SQL statement.*/
1499:
1500: l_person_id per_people_f.person_id%type;
1501: l_assignment_id per_assignments_f.assignment_id%type;
1502: l_tax_unit_id hr_organization_units.organization_id%type;
1503: l_effective_end_date date;
1504:
1505: /* Variables used to hold the values used as bind variables within the

Line 1542: l_prev_asg_id per_assignments_f.assignment_id%type;

1538: checking against the new values returned from within the loop on the
1539: next iteration. */
1540:
1541: l_prev_person_id per_people_f.person_id%type;
1542: l_prev_asg_id per_assignments_f.assignment_id%type;
1543: l_prev_tax_unit_id hr_organization_units.organization_id%type;
1544:
1545: /* general process variables */
1546:

Line 2867: per_assignments_f paf1,

2863:
2864: cursor c_get_city is
2865: select distinct pcty.jurisdiction_code pcty
2866: from pay_us_emp_city_tax_rules_f pcty,
2867: per_assignments_f paf1,
2868: per_assignments_f paf
2869: where paf.assignment_id = l_asgid
2870: and paf.effective_end_date >= l_period_start
2871: and paf.effective_start_date <= l_period_end

Line 2868: per_assignments_f paf

2864: cursor c_get_city is
2865: select distinct pcty.jurisdiction_code pcty
2866: from pay_us_emp_city_tax_rules_f pcty,
2867: per_assignments_f paf1,
2868: per_assignments_f paf
2869: where paf.assignment_id = l_asgid
2870: and paf.effective_end_date >= l_period_start
2871: and paf.effective_start_date <= l_period_end
2872: and paf1.person_id = paf.person_id