[Home] [Help]
455: p_dimension IN CHAR) IS
456: SELECT pdb.defined_balance_id
457: FROM pay_balance_types pbt,
458: pay_balance_dimensions pbd,
459: pay_defined_balances pdb
460: WHERE pdb.balance_type_id = pbt.balance_type_id
461: AND pdb.balance_dimension_id = pbd.balance_dimension_id
462: AND pbt.balance_name = p_balance
463: AND pbd.database_item_suffix = p_dimension
947: SELECT pdb.defined_balance_id
948: FROM
949: pay_balance_dimensions pbd
950: ,pay_balance_types pbt
951: ,pay_defined_balances pdb
952: WHERE
953: pbd.dimension_name = p_dimension_name
954: AND pbd.business_group_id is null
955: AND pbd.legislation_code='IE'
1040: SELECT context_id
1041: FROM ff_contexts
1042: WHERE context_name = 'SOURCE_TEXT';
1043: l_context_id ff_contexts.context_id%TYPE;
1044: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1045: v_class varchar2(30);
1046:
1047:
1048: CURSOR Cur_Act_Contexts(l_defined_bal_id number,p_context_value varchar2) IS
1098:
1099:
1100:
1101: -- Variables to store K, M and Total Insurable Weeks
1102: k_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;
1103: m_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;
1104: pay_act_id number := NULL;
1105:
1106: l_proc VARCHAR2(60) := g_package || 'archive_employee_details';
1099:
1100:
1101: -- Variables to store K, M and Total Insurable Weeks
1102: k_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;
1103: m_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;
1104: pay_act_id number := NULL;
1105:
1106: l_proc VARCHAR2(60) := g_package || 'archive_employee_details';
1107: l_prsi_count NUMBER(1) := 0; --bug 4724788
1529: -- Cursor for retrieving balance type id of defined balance
1530: --
1531: CURSOR csr_bal_type IS
1532: select balance_type_id
1533: from pay_defined_balances
1534: where defined_balance_id = p_defined_bal_id;
1535: -- Cursor for retrieving the summed run results for
1536: -- PRSI insurable weeks where Contribution Class
1537: -- starts with IE_A
1687: cursor csr_defined_bal_id(p_balance_name varchar2) is
1688: select defined_balance_id
1689: from pay_balance_types pbt,
1690: pay_balance_dimensions pbd,
1691: pay_defined_balances pdb
1692: where pbt.balance_name = p_balance_name
1693: and pbt.balance_type_id = pdb.balance_type_id
1694: and pbd.database_item_suffix = '_ASG_PAYE_REF_PRSI_RUN'
1695: and pbd.balance_dimension_id = pdb.balance_dimension_id
1699: cursor csr_usc_defined_bal_id(p_balance_name varchar2) is
1700: select defined_balance_id
1701: from pay_balance_types pbt,
1702: pay_balance_dimensions pbd,
1703: pay_defined_balances pdb
1704: where pbt.balance_name = p_balance_name
1705: and pbt.balance_type_id = pdb.balance_type_id
1706: and pbd.database_item_suffix = p_dimension
1707: and pbd.balance_dimension_id = pdb.balance_dimension_id
2397: -- Cursor for retrieving balance type id of defined balance
2398: --
2399: CURSOR csr_bal_type IS
2400: select balance_type_id
2401: from pay_defined_balances
2402: where defined_balance_id = p_defined_bal_id;
2403:
2404: CURSOR csr_get_curr_val(p_action_context_id NUMBER,p_def_bal_id NUMBER) IS
2405: SELECT to_number(pai.action_information4) balance_value
2421: cursor csr_usc_defined_bal_id(p_balance_name varchar2) is
2422: select defined_balance_id
2423: from pay_balance_types pbt,
2424: pay_balance_dimensions pbd,
2425: pay_defined_balances pdb
2426: where pbt.balance_name = p_balance_name
2427: and pbt.balance_type_id = pdb.balance_type_id
2428: and pbd.database_item_suffix = '_PER_PAYE_REF_YTD'
2429: and pbd.balance_dimension_id = pdb.balance_dimension_id
2858: CURSOR cur_defined_balance(l_balance_name IN varchar2 ) IS
2859: SELECT pdb.defined_balance_id
2860: FROM pay_balance_types pbt,
2861: pay_balance_dimensions pbd,
2862: pay_defined_balances pdb
2863: WHERE pdb.balance_type_id = pbt.balance_type_id
2864: AND pdb.balance_dimension_id = pbd.balance_dimension_id
2865: AND UPPER(pbt.balance_name) = UPPER(l_balance_name)
2866: AND pbd.database_item_suffix = '_PER_PAYE_REF_YTD';