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

Line 331: pay_assignment_actions act,

327: --
328: CURSOR c_chk_archive IS
329: SELECT 'Y' found_flag
330: FROM pay_action_information pai,
331: pay_assignment_actions act,
332: pay_payroll_actions ppa
333: WHERE ppa.report_type = 'P46_CAR_EDI'
334: AND ppa.report_qualifier='GB'
335: AND ppa.report_category ='EDI'

Line 385: pay_assignment_actions act,

381: --
382: CURSOR c_chk_archive IS
383: SELECT 'Y' found_flag
384: FROM pay_action_information pai,
385: pay_assignment_actions act,
386: pay_payroll_actions ppa
387: WHERE ppa.report_type IN ('P46_CAR_EDI_V2','P46_CAR_EDI','P46_CAR_EDI_V3','P46_CAR_EDI_V4','P46_CAR_EDI_V5') --Bug 10095492: Added V4 --Bug 13400872: Added V5
388: AND ppa.report_qualifier='GB'
389: AND ppa.report_category ='EDI'

Line 821: l_actid pay_assignment_actions.assignment_action_id%TYPE;

817: endperson IN NUMBER,
818: chunk IN NUMBER) IS
819: --
820: l_proc CONSTANT VARCHAR2(35):= g_package||'create_asg_act';
821: l_actid pay_assignment_actions.assignment_action_id%TYPE;
822: l_ovn pay_action_information.object_version_number%TYPE;
823: --
824: --
825: CURSOR c_param_values IS

Line 1246: SELECT pay_assignment_actions_s.nextval

1242: --
1243: -- If flag is set then create action
1244: IF l_create_assact_flag = 'Y' THEN
1245: --
1246: SELECT pay_assignment_actions_s.nextval
1247: INTO l_actid
1248: FROM dual;
1249:
1250: hr_utility.set_location(l_proc, 270);

Line 1286: l_actid pay_assignment_actions.assignment_action_id%TYPE;

1282: endperson IN NUMBER,
1283: chunk IN NUMBER) IS
1284: --
1285: l_proc CONSTANT VARCHAR2(100):= g_package||'create_asg_act_v3';
1286: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1287: l_ovn pay_action_information.object_version_number%TYPE;
1288: --
1289: --
1290: CURSOR c_param_values IS

Line 1780: SELECT pay_assignment_actions_s.nextval

1776: --
1777: -- If flag is set then create action
1778: IF l_create_assact_flag = 'Y' THEN
1779: --
1780: SELECT pay_assignment_actions_s.nextval
1781: INTO l_actid
1782: FROM dual;
1783:
1784: hr_utility.set_location(l_proc, 270);

Line 1820: l_actid pay_assignment_actions.assignment_action_id%TYPE;

1816: endperson IN NUMBER,
1817: chunk IN NUMBER) IS
1818: --
1819: l_proc CONSTANT VARCHAR2(100):= g_package||'create_asg_act_v4';
1820: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1821: l_ovn pay_action_information.object_version_number%TYPE;
1822: --
1823: --
1824: CURSOR c_param_values IS

Line 2320: SELECT pay_assignment_actions_s.nextval

2316: --
2317: -- If flag is set then create action
2318: IF l_create_assact_flag = 'Y' THEN
2319: --
2320: SELECT pay_assignment_actions_s.nextval
2321: INTO l_actid
2322: FROM dual;
2323:
2324: hr_utility.set_location(l_proc, 270);

Line 2360: l_actid pay_assignment_actions.assignment_action_id%TYPE;

2356: endperson IN NUMBER,
2357: chunk IN NUMBER) IS
2358: --
2359: l_proc CONSTANT VARCHAR2(100):= g_package||'create_asg_act_v5';
2360: l_actid pay_assignment_actions.assignment_action_id%TYPE;
2361: l_ovn pay_action_information.object_version_number%TYPE;
2362: --
2363: --
2364: CURSOR c_param_values IS

Line 2860: SELECT pay_assignment_actions_s.nextval

2856: --
2857: -- If flag is set then create action
2858: IF l_create_assact_flag = 'Y' THEN
2859: --
2860: SELECT pay_assignment_actions_s.nextval
2861: INTO l_actid
2862: FROM dual;
2863:
2864: hr_utility.set_location(l_proc, 270);

Line 3362: pay_assignment_actions act

3358: max(asg.effective_end_date) asg_max_end_date
3359: FROM hr_soft_coding_keyflex flex,
3360: per_all_assignments_f asg,
3361: Pay_payrolls_f ppf,
3362: pay_assignment_actions act
3363: WHERE act.assignment_action_id = p_assactid
3364: AND act.assignment_id = asg.assignment_id
3365: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)
3366: AND asg.payroll_id = ppf.payroll_id

Line 3798: pay_assignment_actions act

3794: max(asg.effective_end_date) asg_max_end_date
3795: FROM hr_soft_coding_keyflex flex,
3796: per_all_assignments_f asg,
3797: Pay_payrolls_f ppf,
3798: pay_assignment_actions act
3799: WHERE act.assignment_action_id = p_assactid
3800: AND act.assignment_id = asg.assignment_id
3801: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)
3802: AND asg.payroll_id = ppf.payroll_id

Line 4297: pay_assignment_actions act

4293: max(asg.effective_end_date) asg_max_end_date
4294: FROM hr_soft_coding_keyflex flex,
4295: per_all_assignments_f asg,
4296: Pay_payrolls_f ppf,
4297: pay_assignment_actions act
4298: WHERE act.assignment_action_id = p_assactid
4299: AND act.assignment_id = asg.assignment_id
4300: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)
4301: AND asg.payroll_id = ppf.payroll_id

Line 4803: pay_assignment_actions act

4799: max(asg.effective_end_date) asg_max_end_date
4800: FROM hr_soft_coding_keyflex flex,
4801: per_all_assignments_f asg,
4802: Pay_payrolls_f ppf,
4803: pay_assignment_actions act
4804: WHERE act.assignment_action_id = p_assactid
4805: AND act.assignment_id = asg.assignment_id
4806: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)
4807: AND asg.payroll_id = ppf.payroll_id