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_PAYROLL_ACTIONS

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 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 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 2193: ,pay_payroll_actions BACT

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
2197: ,per_time_periods PPTP

Line 2196: ,pay_payroll_actions PACT

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
2200: ,pay_balance_feeds_f FEED

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 2888: FROM pay_payroll_actions

2884: Begin
2885: SELECT count( distinct PAA.PRE_PAYMENT_PAYROLL_ACTION_ID) into l_dummy FROM
2886: (
2887: SELECT DISTINCT payroll_action_id PRE_PAYMENT_PAYROLL_ACTION_ID
2888: FROM pay_payroll_actions
2889: WHERE payroll_action_id IN
2890: (
2891: SELECT DISTINCT payroll_action_id
2892: FROM pay_assignment_actions

Line 3205: pay_payroll_actions ppa

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
3206: WHERE ppa.payroll_action_id = L_PAYROLL_ACTION_ID
3207: AND paa.payroll_action_id = ppa.payroll_action_id
3208: AND paaf.assignment_id = paa.assignment_id
3209: AND paaf.payroll_id = ppf.payroll_id

Line 3239: FROM pay_payroll_actions

3235: B_PAYROLL_ACTION_ID := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3236: fnd_file.put_line(FND_FILE.LOG,' BACS Payroll Action ID :'|| B_PAYROLL_ACTION_ID);
3237: OPEN C_PREPAY_PAYROLL_ACTN_ID FOR
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

Line 3258: FROM pay_payroll_actions

3254: ELSE
3255: hr_utility.trace(' Called from FPS with Pre Payment payroll action id ');
3256: OPEN C_PREPAY_PAYROLL_ACTN_ID FOR
3257: SELECT DISTINCT payroll_action_id
3258: FROM pay_payroll_actions
3259: WHERE payroll_action_id = P_PAYROLL_ACTION_ID
3260: ORDER BY payroll_action_id Nulls Last;
3261: END IF;
3262: LOOP

Line 3282: FROM pay_payroll_actions

3278: -- check whether the RTI live is for specific PAYE ref
3279: IF l_uptake_value = 'PARTIAL' THEN
3280: SELECT effective_date
3281: INTO l_effective_date
3282: FROM pay_payroll_actions
3283: WHERE payroll_action_id = L_PAYROLL_ACTION_ID;
3284: OPEN get_paye_ref(l_effective_date);
3285: FETCH get_paye_ref INTO l_business_group_id, l_tax_ref;
3286: CLOSE get_paye_ref;

Line 3384: pay_payroll_actions ppa

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
3386: AND pppf.personal_payment_method_ID = ppp.personal_payment_method_ID
3387: AND popf.PAYMENT_TYPE_ID = ppt.PAYMENT_TYPE_ID
3388: AND ppt.PAYMENT_TYPE_NAME = 'BACS Tape'