APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_RUN_TYPES_F

Line 1675: FROM pay_run_types_f

1671: SELECT
1672: run_type_id, run_type_name, run_method, effective_start_date, effective_end_date,
1673: business_group_id, legislation_code, shortname, last_update_date, last_updated_by,
1674: last_update_login, created_by, creation_date, object_version_number
1675: FROM pay_run_types_f
1676: WHERE nvl(legislation_code,'X') = 'ZZ'
1677: AND business_group_id IS NULL and sysdate between effective_start_date and effective_end_date;
1678:
1679:

Line 1682: FROM pay_run_types_f

1678:
1679:
1680: Cursor run_type_parent_csr (l_legislation_code IN VARCHAR2) IS
1681: SELECT run_type_id parent_id
1682: FROM pay_run_types_f
1683: WHERE (run_type_name,shortname) IN (SELECT RUN_TYPE_NAME, shortname from pay_run_types_f
1684: WHERE RUN_TYPE_ID IN (SELECT PARENT_RUN_TYPE_ID
1685: FROM pay_run_type_usages_f
1686: WHERE LEGISLATION_CODE = 'ZZ'

Line 1683: WHERE (run_type_name,shortname) IN (SELECT RUN_TYPE_NAME, shortname from pay_run_types_f

1679:
1680: Cursor run_type_parent_csr (l_legislation_code IN VARCHAR2) IS
1681: SELECT run_type_id parent_id
1682: FROM pay_run_types_f
1683: WHERE (run_type_name,shortname) IN (SELECT RUN_TYPE_NAME, shortname from pay_run_types_f
1684: WHERE RUN_TYPE_ID IN (SELECT PARENT_RUN_TYPE_ID
1685: FROM pay_run_type_usages_f
1686: WHERE LEGISLATION_CODE = 'ZZ'
1687: AND sysdate BETWEEN EFFECTIVE_START_DATE

Line 1700: FROM pay_run_types_f prtf1, pay_run_types_f prtf2 , pay_run_type_usages_f prtuf

1696: AND business_group_id is NULL;
1697:
1698: Cursor run_type_child_csr (l_legislation_code IN VARCHAR2) IS
1699: SELECT prtf1.run_type_id child_id , prtuf.sequence sequence , prtf1.run_type_name run_type_name
1700: FROM pay_run_types_f prtf1, pay_run_types_f prtf2 , pay_run_type_usages_f prtuf
1701: WHERE (prtf1.run_type_name,prtf1.shortname) IN (SELECT RUN_TYPE_NAME, shortname
1702: FROM pay_run_types_f
1703: WHERE RUN_TYPE_ID IN (SELECT child_RUN_TYPE_ID
1704: FROM pay_run_type_usages_f

Line 1702: FROM pay_run_types_f

1698: Cursor run_type_child_csr (l_legislation_code IN VARCHAR2) IS
1699: SELECT prtf1.run_type_id child_id , prtuf.sequence sequence , prtf1.run_type_name run_type_name
1700: FROM pay_run_types_f prtf1, pay_run_types_f prtf2 , pay_run_type_usages_f prtuf
1701: WHERE (prtf1.run_type_name,prtf1.shortname) IN (SELECT RUN_TYPE_NAME, shortname
1702: FROM pay_run_types_f
1703: WHERE RUN_TYPE_ID IN (SELECT child_RUN_TYPE_ID
1704: FROM pay_run_type_usages_f
1705: WHERE parent_run_type_id in (SELECT distinct PARENT_RUN_TYPE_ID
1706: FROM pay_run_type_usages_f

Line 1732: l_rt_id pay_run_types_f.run_type_id%TYPE;

1728:
1729:
1730: --local variables for Run Types
1731:
1732: l_rt_id pay_run_types_f.run_type_id%TYPE;
1733: l_rt_ovn pay_run_types_f.object_version_number%TYPE;
1734: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;
1735: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
1736:

Line 1733: l_rt_ovn pay_run_types_f.object_version_number%TYPE;

1729:
1730: --local variables for Run Types
1731:
1732: l_rt_id pay_run_types_f.run_type_id%TYPE;
1733: l_rt_ovn pay_run_types_f.object_version_number%TYPE;
1734: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;
1735: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
1736:
1737: --local variables for Run Type Usages

Line 1734: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;

1730: --local variables for Run Types
1731:
1732: l_rt_id pay_run_types_f.run_type_id%TYPE;
1733: l_rt_ovn pay_run_types_f.object_version_number%TYPE;
1734: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;
1735: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
1736:
1737: --local variables for Run Type Usages
1738:

Line 1735: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;

1731:
1732: l_rt_id pay_run_types_f.run_type_id%TYPE;
1733: l_rt_ovn pay_run_types_f.object_version_number%TYPE;
1734: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;
1735: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
1736:
1737: --local variables for Run Type Usages
1738:
1739: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;

Line 1762: FROM pay_run_types_f

1758:
1759: BEGIN
1760: SELECT run_type_id, object_version_number
1761: INTO l_rt_id, l_rt_ovn
1762: FROM pay_run_types_f
1763: WHERE run_type_name = rec.run_type_name
1764: AND shortname = rec.shortname
1765: AND legislation_code = p_legislation_code
1766: AND sysdate between effective_start_date and effective_end_date

Line 1920: FROM pay_run_types_f_tl t, pay_run_types_f b

1916:
1917: CURSOR get_runid_btable_csr IS
1918: SELECT b.run_type_id bid , b.run_type_name bname,
1919: t.language, t.run_type_name tname, t.shortname, t.source_lang
1920: FROM pay_run_types_f_tl t, pay_run_types_f b
1921: WHERE t.run_type_id = b.run_type_id
1922: AND b.legislation_code = 'ZZ'
1923: AND b.business_group_id IS NULL
1924: AND sysdate BETWEEN b.effective_start_date AND b.effective_end_date ;

Line 1928: FROM pay_run_types_f_tl t, pay_run_types_f b

1924: AND sysdate BETWEEN b.effective_start_date AND b.effective_end_date ;
1925:
1926: CURSOR get_runid_tltable_csr(l_legislation_code VARCHAR2, l_name VARCHAR2, l_language VARCHAR2) IS
1927: SELECT t.run_type_id tlid
1928: FROM pay_run_types_f_tl t, pay_run_types_f b
1929: WHERE b.run_type_name = l_name
1930: AND b.legislation_code = l_legislation_code
1931: AND b.business_group_id IS NULL
1932: AND t.run_type_id = b.run_type_id

Line 1948: UPDATE pay_run_types_f_tl

1944: fetch get_runid_tltable_csr INTO rec_tltable_csr ;
1945:
1946: if get_runid_tltable_csr%found then
1947:
1948: UPDATE pay_run_types_f_tl
1949: SET run_type_name = l_record.tname,
1950: shortname = l_record.shortname,
1951: source_lang = l_record.source_lang
1952: WHERE run_type_id = rec_tltable_csr.tlid