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 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1054: FROM pay_assignment_actions

1050:
1051: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
1052: IS
1053: SELECT ASSIGNMENT_ACTION_ID
1054: FROM pay_assignment_actions
1055: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1056: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1057: IS
1058: SELECT pdb.defined_balance_id

Line 1073: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

1069: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1070: FROM dual;
1071:
1072: cursor csr_reversal is
1073: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1074: where paa.assignment_action_id = l_last_asg_action_id
1075: and paa.payroll_action_id = ppa.payroll_action_id
1076: and ACTION_TYPE in ('V');
1077:

Line 1378: FROM pay_assignment_actions

1374:
1375: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
1376: IS
1377: SELECT ASSIGNMENT_ACTION_ID
1378: FROM pay_assignment_actions
1379: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1380: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1381: IS
1382: SELECT pdb.defined_balance_id

Line 1397: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

1393: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1394: FROM dual;
1395:
1396: cursor csr_reversal is
1397: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1398: where paa.assignment_action_id = l_last_asg_action_id
1399: and paa.payroll_action_id = ppa.payroll_action_id
1400: and ACTION_TYPE in ('V');
1401:

Line 1708: FROM pay_assignment_actions

1704:
1705: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
1706: IS
1707: SELECT ASSIGNMENT_ACTION_ID
1708: FROM pay_assignment_actions
1709: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1710:
1711:
1712: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)

Line 1730: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

1726: FROM dual;
1727:
1728:
1729: cursor csr_reversal is
1730: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1731: where paa.assignment_action_id = l_last_asg_action_id
1732: and paa.payroll_action_id = ppa.payroll_action_id
1733: and ACTION_TYPE in ('V');
1734:

Line 2204: pay_assignment_actions BAL_ASSACT

2200: select sum(target.result_value)
2201: into
2202: l_value
2203: from
2204: pay_assignment_actions BAL_ASSACT
2205: ,pay_payroll_actions BACT
2206: ,per_time_periods BPTP
2207: ,pay_assignment_actions ASSACT
2208: ,pay_payroll_actions PACT

Line 2207: ,pay_assignment_actions ASSACT

2203: from
2204: pay_assignment_actions BAL_ASSACT
2205: ,pay_payroll_actions BACT
2206: ,per_time_periods BPTP
2207: ,pay_assignment_actions ASSACT
2208: ,pay_payroll_actions PACT
2209: ,per_time_periods PPTP
2210: ,pay_run_results RR
2211: ,pay_run_result_values TARGET

Line 2369: FROM pay_assignment_actions

2365:
2366: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
2367: IS
2368: SELECT ASSIGNMENT_ACTION_ID
2369: FROM pay_assignment_actions
2370: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2371: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2372: IS
2373: SELECT pdb.defined_balance_id

Line 2388: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

2384: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2385: FROM dual;
2386:
2387: cursor csr_reversal is
2388: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2389: where paa.assignment_action_id = l_last_asg_action_id
2390: and paa.payroll_action_id = ppa.payroll_action_id
2391: and ACTION_TYPE in ('V');
2392:

Line 2647: FROM pay_assignment_actions

2643: l_tax_pay_val NUMBER;
2644: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
2645: IS
2646: SELECT ASSIGNMENT_ACTION_ID
2647: FROM pay_assignment_actions
2648: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2649: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2650: IS
2651: SELECT pdb.defined_balance_id

Line 2897: FROM pay_assignment_actions

2893: FROM pay_payroll_actions
2894: WHERE payroll_action_id IN
2895: (
2896: SELECT DISTINCT payroll_action_id
2897: FROM pay_assignment_actions
2898: WHERE assignment_action_id IN
2899: (
2900: SELECT LOCKED_ACTION_ID
2901: FROM pay_action_interlocks

Line 2905: FROM pay_assignment_actions

2901: FROM pay_action_interlocks
2902: WHERE locking_action_id IN
2903: (
2904: SELECT ASSIGNMENT_ACTION_ID
2905: FROM pay_assignment_actions
2906: WHERE payroll_action_id = L_PAYROLL_ACTION_ID
2907: )
2908: )
2909: )

Line 2939: pay_assignment_actions paa

2935:
2936: SELECT RANDOM_STRING
2937: INTO L_RANDOM
2938: FROM PAY_GB_BACS_FPS bacs,
2939: pay_assignment_actions paa
2940: WHERE paa.payroll_action_id = L_PAYROLL_ACTION_ID -- CONTEXT (BACS payroll action id)
2941: and paa.ASSIGNMENT_action_id = L_ASSIGNMENT_ACTION_ID -- CONTEXT (BACS ASSIGNMENT action id)
2942: AND paa.pre_payment_id = bacs.pre_payment_id
2943: AND BACS.ORG_SORT_CODE = P_ORG_SORT_CODE --PARAMETER

Line 3206: FROM pay_assignment_actions paa,

3202: CURSOR get_paye_ref(c_effective_date DATE)
3203: IS
3204: SELECT paaf.business_group_id,
3205: flex.segment1
3206: FROM pay_assignment_actions paa,
3207: per_all_assignments_f paaf,
3208: hr_soft_coding_keyflex flex,
3209: pay_payrolls_f ppf,
3210: pay_payroll_actions ppa

Line 3247: FROM pay_assignment_actions

3243: SELECT DISTINCT payroll_action_id
3244: FROM pay_payroll_actions
3245: WHERE payroll_action_id IN
3246: ( SELECT DISTINCT payroll_action_id
3247: FROM pay_assignment_actions
3248: WHERE assignment_action_id IN
3249: (SELECT LOCKED_ACTION_ID
3250: FROM pay_action_interlocks
3251: WHERE locking_action_id IN

Line 3253: FROM pay_assignment_actions

3249: (SELECT LOCKED_ACTION_ID
3250: FROM pay_action_interlocks
3251: WHERE locking_action_id IN
3252: (SELECT ASSIGNMENT_ACTION_ID
3253: FROM pay_assignment_actions
3254: WHERE payroll_action_id = B_PAYROLL_ACTION_ID
3255: )
3256: )
3257: )

Line 3386: PAY_ASSIGNMENT_ACTIONS PAA,

3382: pay_org_payment_methods_f popf,
3383: pay_personal_payment_methods_f pppf,
3384: pay_external_accounts Orgkey,
3385: pay_external_accounts deskey,
3386: PAY_ASSIGNMENT_ACTIONS PAA,
3387: PER_ALL_PEOPLE_F PAPF,
3388: per_all_assignments_f paaf,
3389: pay_payroll_actions ppa
3390: WHERE popf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID

Line 3545: FROM pay_assignment_actions paa,

3541: pai.action_information12, --PENSIONER
3542: pai.action_information4, --STARTER
3543: pai.action_information5, --STARTER
3544: pai.action_information20 -- Number of Periods Covered
3545: FROM pay_assignment_actions paa,
3546: pay_action_information pai
3547: WHERE paa.payroll_action_id = p_pactid
3548: AND paa.assignment_action_id = pai.action_context_id
3549: AND pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'