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_PAYROLL_ACTIONS

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

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

Line 2208: ,pay_payroll_actions PACT

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

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

2889: Begin
2890: SELECT count( distinct PAA.PRE_PAYMENT_PAYROLL_ACTION_ID) into l_dummy FROM
2891: (
2892: SELECT DISTINCT payroll_action_id PRE_PAYMENT_PAYROLL_ACTION_ID
2893: FROM pay_payroll_actions
2894: WHERE payroll_action_id IN
2895: (
2896: SELECT DISTINCT payroll_action_id
2897: FROM pay_assignment_actions

Line 3210: pay_payroll_actions ppa

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
3211: WHERE ppa.payroll_action_id = L_PAYROLL_ACTION_ID
3212: AND paa.payroll_action_id = ppa.payroll_action_id
3213: AND paaf.assignment_id = paa.assignment_id
3214: AND paaf.payroll_id = ppf.payroll_id

Line 3244: FROM pay_payroll_actions

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

Line 3263: FROM pay_payroll_actions

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

Line 3287: FROM pay_payroll_actions

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

Line 3389: pay_payroll_actions ppa

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
3391: AND pppf.personal_payment_method_ID = ppp.personal_payment_method_ID
3392: AND popf.PAYMENT_TYPE_ID = ppt.PAYMENT_TYPE_ID
3393: AND ppt.PAYMENT_TYPE_NAME = 'BACS Tape'