APPS.PAY_US_PSD_GENERIC_EXTRACT dependencies on HR_US_W2_REP

Line 353: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,

349:
350: if ltr_ue_name_table.count > 0 then
351: for j in ltr_ue_name_table.first .. ltr_ue_name_table.last
352: loop
353: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,
354: l_payroll_action_id,
355: ltr_ue_name_table(j).ue_name);
356: end loop;
357: end if;

Line 888: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,

884: exception when no_data_found then
885: hr_utility_trace ('populate_arch_employer: getting PSd Reporting Rules (ER) archvied values '||SQLERRM);
886: end;
887: else
888: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,
889: l_payroll_action_id,
890: ltr_ue_name_table(j).ue_name);
891: end if;
892: end loop;

Line 1577: hr_us_w2_rep.get_per_item( p_assignment_action_id,

1573: LOOP
1574: IF ltr_ue_name_table(j).ue_data_level = 'PER'
1575: THEN
1576: ltr_ue_name_table(j).ue_value :=
1577: hr_us_w2_rep.get_per_item( p_assignment_action_id,
1578: ltr_ue_name_table(j).ue_name);
1579: ELSIF ltr_ue_name_table(J).ue_data_level ='FED' THEN
1580: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
1581: p_assignment_action_id

Line 1580: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(

1576: ltr_ue_name_table(j).ue_value :=
1577: hr_us_w2_rep.get_per_item( p_assignment_action_id,
1578: ltr_ue_name_table(j).ue_name);
1579: ELSIF ltr_ue_name_table(J).ue_data_level ='FED' THEN
1580: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
1581: p_assignment_action_id
1582: ,ltr_ue_name_table(j).ue_name
1583: ,p_tax_unit_id
1584: ,'00-000-0000'

Line 1600: hr_us_w2_rep.get_w2_arch_bal(

1596: from dual;
1597: END IF;
1598: ELSIF ltr_ue_name_table(J).ue_data_level ='STATE' THEN
1599: ltr_ue_name_table(j).ue_value :=
1600: hr_us_w2_rep.get_w2_arch_bal(
1601: p_assignment_action_id
1602: ,ltr_ue_name_table(j).ue_name
1603: ,p_tax_unit_id
1604: /* Bug 7592972 : State Code should be passed as

Line 1623: hr_us_w2_rep.get_w2_arch_bal(

1619: from dual;
1620: END IF;
1621: ELSIF ltr_ue_name_table(J).ue_data_level ='PSD' THEN
1622: ltr_ue_name_table(j).ue_value :=
1623: hr_us_w2_rep.get_w2_arch_bal(
1624: p_assignment_action_id
1625: ,ltr_ue_name_table(j).ue_name
1626: ,p_tax_unit_id
1627: ,p_jurisdiction_code

Line 1656: hr_us_w2_rep.get_state_item(

1652: from dual;
1653: END IF;
1654: ELSIF ltr_ue_name_table(J).ue_data_level ='GRE' THEN
1655: ltr_ue_name_table(j).ue_value :=
1656: hr_us_w2_rep.get_state_item(
1657: p_tax_unit_id,
1658: /* Bug 7592972 : State Code should be passed as
1659: two character long code
1660: p_state_code||'-000-0000',*/