eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1018: FROM pay_assignment_actions

1014:
1015: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
1016: IS
1017: SELECT ASSIGNMENT_ACTION_ID
1018: FROM pay_assignment_actions
1019: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1020: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1021: IS
1022: SELECT pdb.defined_balance_id

Line 1037: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

1033: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1034: FROM dual;
1035:
1036: cursor csr_reversal is
1037: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1038: where paa.assignment_action_id = l_last_asg_action_id
1039: and paa.payroll_action_id = ppa.payroll_action_id
1040: and ACTION_TYPE in ('V');
1041:

Line 1349: FROM pay_assignment_actions

1345:
1346: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
1347: IS
1348: SELECT ASSIGNMENT_ACTION_ID
1349: FROM pay_assignment_actions
1350: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1351: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1352: IS
1353: SELECT pdb.defined_balance_id

Line 1368: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

1364: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1365: FROM dual;
1366:
1367: cursor csr_reversal is
1368: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1369: where paa.assignment_action_id = l_last_asg_action_id
1370: and paa.payroll_action_id = ppa.payroll_action_id
1371: and ACTION_TYPE in ('V');
1372:

Line 1685: FROM pay_assignment_actions

1681:
1682: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
1683: IS
1684: SELECT ASSIGNMENT_ACTION_ID
1685: FROM pay_assignment_actions
1686: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1687:
1688:
1689: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)

Line 1706: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

1702: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1703: FROM dual;
1704:
1705: cursor csr_reversal is
1706: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1707: where paa.assignment_action_id = l_last_asg_action_id
1708: and paa.payroll_action_id = ppa.payroll_action_id
1709: and ACTION_TYPE in ('V');
1710:

Line 2192: pay_assignment_actions BAL_ASSACT

2188: select sum(target.result_value)
2189: into
2190: l_value
2191: from
2192: pay_assignment_actions BAL_ASSACT
2193: ,pay_payroll_actions BACT
2194: ,per_time_periods BPTP
2195: ,pay_assignment_actions ASSACT
2196: ,pay_payroll_actions PACT

Line 2195: ,pay_assignment_actions ASSACT

2191: from
2192: pay_assignment_actions BAL_ASSACT
2193: ,pay_payroll_actions BACT
2194: ,per_time_periods BPTP
2195: ,pay_assignment_actions ASSACT
2196: ,pay_payroll_actions PACT
2197: ,per_time_periods PPTP
2198: ,pay_run_results RR
2199: ,pay_run_result_values TARGET

Line 2357: FROM pay_assignment_actions

2353:
2354: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
2355: IS
2356: SELECT ASSIGNMENT_ACTION_ID
2357: FROM pay_assignment_actions
2358: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2359: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2360: IS
2361: SELECT pdb.defined_balance_id

Line 2376: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

2372: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2373: FROM dual;
2374:
2375: cursor csr_reversal is
2376: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2377: where paa.assignment_action_id = l_last_asg_action_id
2378: and paa.payroll_action_id = ppa.payroll_action_id
2379: and ACTION_TYPE in ('V');
2380:

Line 2642: FROM pay_assignment_actions

2638: l_tax_pay_val NUMBER;
2639: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
2640: IS
2641: SELECT ASSIGNMENT_ACTION_ID
2642: FROM pay_assignment_actions
2643: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2644: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2645: IS
2646: SELECT pdb.defined_balance_id

Line 2892: FROM pay_assignment_actions

2888: FROM pay_payroll_actions
2889: WHERE payroll_action_id IN
2890: (
2891: SELECT DISTINCT payroll_action_id
2892: FROM pay_assignment_actions
2893: WHERE assignment_action_id IN
2894: (
2895: SELECT LOCKED_ACTION_ID
2896: FROM pay_action_interlocks

Line 2900: FROM pay_assignment_actions

2896: FROM pay_action_interlocks
2897: WHERE locking_action_id IN
2898: (
2899: SELECT ASSIGNMENT_ACTION_ID
2900: FROM pay_assignment_actions
2901: WHERE payroll_action_id = L_PAYROLL_ACTION_ID
2902: )
2903: )
2904: )

Line 2934: pay_assignment_actions paa

2930:
2931: SELECT RANDOM_STRING
2932: INTO L_RANDOM
2933: FROM PAY_GB_BACS_FPS bacs,
2934: pay_assignment_actions paa
2935: WHERE paa.payroll_action_id = L_PAYROLL_ACTION_ID -- CONTEXT (BACS payroll action id)
2936: and paa.ASSIGNMENT_action_id = L_ASSIGNMENT_ACTION_ID -- CONTEXT (BACS ASSIGNMENT action id)
2937: AND paa.pre_payment_id = bacs.pre_payment_id
2938: AND BACS.ORG_SORT_CODE = P_ORG_SORT_CODE --PARAMETER

Line 3201: FROM pay_assignment_actions paa,

3197: CURSOR get_paye_ref(c_effective_date DATE)
3198: IS
3199: SELECT paaf.business_group_id,
3200: flex.segment1
3201: FROM pay_assignment_actions paa,
3202: per_all_assignments_f paaf,
3203: hr_soft_coding_keyflex flex,
3204: pay_payrolls_f ppf,
3205: pay_payroll_actions ppa

Line 3242: FROM pay_assignment_actions

3238: SELECT DISTINCT payroll_action_id
3239: FROM pay_payroll_actions
3240: WHERE payroll_action_id IN
3241: ( SELECT DISTINCT payroll_action_id
3242: FROM pay_assignment_actions
3243: WHERE assignment_action_id IN
3244: (SELECT LOCKED_ACTION_ID
3245: FROM pay_action_interlocks
3246: WHERE locking_action_id IN

Line 3248: FROM pay_assignment_actions

3244: (SELECT LOCKED_ACTION_ID
3245: FROM pay_action_interlocks
3246: WHERE locking_action_id IN
3247: (SELECT ASSIGNMENT_ACTION_ID
3248: FROM pay_assignment_actions
3249: WHERE payroll_action_id = B_PAYROLL_ACTION_ID
3250: )
3251: )
3252: )

Line 3381: PAY_ASSIGNMENT_ACTIONS PAA,

3377: pay_org_payment_methods_f popf,
3378: pay_personal_payment_methods_f pppf,
3379: pay_external_accounts Orgkey,
3380: pay_external_accounts deskey,
3381: PAY_ASSIGNMENT_ACTIONS PAA,
3382: PER_ALL_PEOPLE_F PAPF,
3383: per_all_assignments_f paaf,
3384: pay_payroll_actions ppa
3385: WHERE popf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID

Line 3540: FROM pay_assignment_actions paa,

3536: pai.action_information12, --PENSIONER
3537: pai.action_information4, --STARTER
3538: pai.action_information5, --STARTER
3539: pai.action_information20 -- Number of Periods Covered
3540: FROM pay_assignment_actions paa,
3541: pay_action_information pai
3542: WHERE paa.payroll_action_id = p_pactid
3543: AND paa.assignment_action_id = pai.action_context_id
3544: AND pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'