APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 372: pay_defined_balances pdb

368: p_dimension IN CHAR) IS
369: SELECT pdb.defined_balance_id
370: FROM pay_balance_types pbt,
371: pay_balance_dimensions pbd,
372: pay_defined_balances pdb
373: WHERE pdb.balance_type_id = pbt.balance_type_id
374: AND pdb.balance_dimension_id = pbd.balance_dimension_id
375: AND pbt.balance_name = p_balance
376: AND pbd.database_item_suffix = p_dimension

Line 751: ,pay_defined_balances pdb

747: SELECT pdb.defined_balance_id
748: FROM
749: pay_balance_dimensions pbd
750: ,pay_balance_types pbt
751: ,pay_defined_balances pdb
752: WHERE
753: pbd.dimension_name = p_dimension_name
754: AND pbd.business_group_id is null
755: AND pbd.legislation_code='IE'

Line 831: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

827: SELECT context_id
828: FROM ff_contexts
829: WHERE context_name = 'SOURCE_TEXT';
830: l_context_id ff_contexts.context_id%TYPE;
831: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
832: v_class varchar2(30);
833:
834:
835: CURSOR Cur_Act_Contexts(l_defined_bal_id number,p_context_value varchar2) IS

Line 888: k_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;

884:
885:
886:
887: -- Variables to store K, M and Total Insurable Weeks
888: k_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;
889: m_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;
890: pay_act_id number := NULL;
891:
892: l_proc VARCHAR2(60) := g_package || 'archive_employee_details';

Line 889: m_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;

885:
886:
887: -- Variables to store K, M and Total Insurable Weeks
888: k_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;
889: m_defined_balance_id pay_defined_balances.DEFINED_BALANCE_ID%type := NULL;
890: pay_act_id number := NULL;
891:
892: l_proc VARCHAR2(60) := g_package || 'archive_employee_details';
893: l_prsi_count NUMBER(1) := 0; --bug 4724788

Line 1269: from pay_defined_balances

1265: -- Cursor for retrieving balance type id of defined balance
1266: --
1267: CURSOR csr_bal_type IS
1268: select balance_type_id
1269: from pay_defined_balances
1270: where defined_balance_id = p_defined_bal_id;
1271: -- Cursor for retrieving the summed run results for
1272: -- PRSI insurable weeks where Contribution Class
1273: -- starts with IE_A

Line 1426: pay_defined_balances pdb

1422: cursor csr_defined_bal_id(p_balance_name varchar2) is
1423: select defined_balance_id
1424: from pay_balance_types pbt,
1425: pay_balance_dimensions pbd,
1426: pay_defined_balances pdb
1427: where pbt.balance_name = p_balance_name
1428: and pbt.balance_type_id = pdb.balance_type_id
1429: and pbd.database_item_suffix = '_ASG_PAYE_REF_PRSI_RUN'
1430: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1844: from pay_defined_balances

1840: -- Cursor for retrieving balance type id of defined balance
1841: --
1842: CURSOR csr_bal_type IS
1843: select balance_type_id
1844: from pay_defined_balances
1845: where defined_balance_id = p_defined_bal_id;
1846:
1847: CURSOR csr_get_curr_val(p_action_context_id NUMBER,p_def_bal_id NUMBER) IS
1848: SELECT to_number(pai.action_information4) balance_value

Line 2195: pay_defined_balances pdb

2191: CURSOR cur_defined_balance(l_balance_name IN varchar2 ) IS
2192: SELECT pdb.defined_balance_id
2193: FROM pay_balance_types pbt,
2194: pay_balance_dimensions pbd,
2195: pay_defined_balances pdb
2196: WHERE pdb.balance_type_id = pbt.balance_type_id
2197: AND pdb.balance_dimension_id = pbd.balance_dimension_id
2198: AND UPPER(pbt.balance_name) = UPPER(l_balance_name)
2199: AND pbd.database_item_suffix = '_PER_PAYE_REF_YTD';