APPS.PAY_FI_ARCHIVE_PSTA dependencies on HR_GENERAL

Line 235: g_payroll_type := hr_general.decode_lookup ('FI_PROC_PERIOD_TYPE', g_payroll_type_code);

231: g_effective_date
232: );
233:
234: if g_archive = 'Y' then
235: g_payroll_type := hr_general.decode_lookup ('FI_PROC_PERIOD_TYPE', g_payroll_type_code);
236:
237: /* Get the Last Date of the Year */
238: select fnd_date.canonical_to_date (g_year || '12/31')
239: into g_year_last_date

Line 307: l_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_get_org_address.postal_code);

303: fetch csr_get_org_address into rl_get_org_address;
304: close csr_get_org_address;
305:
306: if rl_get_org_address.style = 'FI' then
307: l_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_get_org_address.postal_code);
308: else
309: l_postal_code := rl_get_org_address.postal_code;
310: end if;
311:

Line 822: hr_general.decode_lookup (

818: );
819:
820: if car_element_detail.lookup_type is not null then
821: car_element_detail.screen_entry_value :=
822: hr_general.decode_lookup (
823: car_element_detail.lookup_type,
824: car_element_detail.screen_entry_value
825: );
826: end if;

Line 878: g_payroll_type := hr_general.decode_lookup ('FI_PROC_PERIOD_TYPE', g_payroll_type_code);

874: g_payroll_id,
875: g_archive,
876: g_effective_date
877: );
878: g_payroll_type := hr_general.decode_lookup ('FI_PROC_PERIOD_TYPE', g_payroll_type_code);
879:
880: g_arch_payroll_action_id := p_payroll_action_id;
881:
882: --

Line 1348: l_tax_card_type := hr_general.decode_lookup ('FI_TAX_CARD_TYPE', l_tax_card_type_code);

1344:
1345: --
1346: --
1347: if l_tax_card_type_code is not null then
1348: l_tax_card_type := hr_general.decode_lookup ('FI_TAX_CARD_TYPE', l_tax_card_type_code);
1349: else
1350: l_tax_card_type := null;
1351: end if;
1352:

Line 1360: l_tax_municipality := hr_general.decode_lookup ('FI_TAX_MUNICIPALITY', l_tax_municipality_code);

1356: close get_element_details;
1357:
1358: --
1359: --
1360: l_tax_municipality := hr_general.decode_lookup ('FI_TAX_MUNICIPALITY', l_tax_municipality_code);
1361: /* Get the Base Rate */
1362: open get_element_details (i.assignment_id, 'Tax Card', 'Base Rate', l_effective_date);
1363: fetch get_element_details into l_base_rate;
1364: close get_element_details;

Line 1447: l_hourly_salaried_code := hr_general.decode_lookup ('HOURLY_SALARIED_CODE', i.hourly_salaried_code);

1443: );
1444:
1445: /* Get the Type of Benefit in Kind*/
1446: if i.hourly_salaried_code is not null then
1447: l_hourly_salaried_code := hr_general.decode_lookup ('HOURLY_SALARIED_CODE', i.hourly_salaried_code);
1448: else
1449: l_hourly_salaried_code := null;
1450: end if;
1451:

Line 1457: l_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_primary_address.postal_code);

1453: fetch csr_primary_address into rl_primary_address;
1454: close csr_primary_address;
1455:
1456: if rl_primary_address.style = 'FI' then
1457: l_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_primary_address.postal_code);
1458: else
1459: l_postal_code := rl_primary_address.postal_code;
1460: end if;
1461:

Line 1469: l_permanent_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_permanent_address.postal_code);

1465: fetch csr_permanent_address into rl_permanent_address;
1466: close csr_permanent_address;
1467:
1468: if rl_permanent_address.style = 'FI' then
1469: l_permanent_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_permanent_address.postal_code);
1470: else
1471: l_permanent_postal_code := rl_permanent_address.postal_code;
1472: end if;
1473:

Line 1727: l_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_primary_address.postal_code);

1723: fetch csr_primary_address into rl_primary_address;
1724: close csr_primary_address;
1725:
1726: if rl_primary_address.style = 'FI' then
1727: l_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_primary_address.postal_code);
1728: else
1729: l_postal_code := rl_primary_address.postal_code;
1730: end if;
1731:

Line 1739: l_permanent_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_permanent_address.postal_code);

1735: fetch csr_permanent_address into rl_permanent_address;
1736: close csr_permanent_address;
1737:
1738: if rl_permanent_address.style = 'FI' then
1739: l_permanent_postal_code := hr_general.decode_lookup ('FI_POSTAL_CODE', rl_permanent_address.postal_code);
1740: else
1741: l_permanent_postal_code := rl_permanent_address.postal_code;
1742: end if;
1743: