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.PSP_LABOR_DIST dependencies on PSP_PAYROLL_CONTROLS

Line 62: FROM psp_payroll_controls

58: CURSOR payroll_control_cur IS
59: SELECT payroll_control_id,
60: source_type, /* Bug 1874696 Introduced source type */
61: currency_code -- Introduced for bug fix 2916848
62: FROM psp_payroll_controls
63: WHERE cdl_payroll_Action_id = g_payroll_action_id;
64:
65:
66: /* Bug 2663344 reverted change done for 1874696,re-introduced per_time_periods */

Line 102: psp_payroll_controls ppc

98: or_expenditure_type
99: FROM psp_payroll_lines ppl,
100: psp_payroll_sub_lines ppsl,
101: per_time_periods ptp,
102: psp_payroll_controls ppc
103: WHERE ppl.payroll_line_id = ppsl.payroll_line_id
104: AND ppl.status_code = 'N'
105: AND ppsl.pay_amount <> 0
106: AND ppl.payroll_control_id = p_payroll_control_id

Line 5271: psp_payroll_controls_s.nextval

5267:
5268: -- dbms_output.put_line('Entered create master');
5269: select psp_payroll_lines_s.nextval,
5270: psp_payroll_sub_lines_s.nextval,
5271: psp_payroll_controls_s.nextval
5272: into l_line_id,
5273: g_sub_line_id,
5274: l_control_id
5275: from dual;

Line 6895: from psp_payroll_controls

6891: cursor get_control_details(p_payroll_control_id integer) is
6892: select time_period_id,
6893: payroll_id,
6894: currency_code
6895: from psp_payroll_controls
6896: where payroll_control_id = p_payroll_control_id;
6897:
6898: control_details_rec get_control_details%rowtype;
6899:

Line 7139: psp_payroll_controls ppc,

7135: From psp_schedule_lines psl,
7136: psp_organization_accounts pod,
7137: psp_element_type_accounts pea,
7138: psp_default_labor_schedules pdls,
7139: psp_payroll_controls ppc,
7140: psp_payroll_lines ppl,
7141: psp_payroll_sub_lines ppsl,
7142: gms_awards_all awd,
7143: psp_distribution_lines pdl

Line 7193: psp_payroll_controls ppc,

7189: From psp_schedule_lines psl,
7190: psp_organization_accounts pod,
7191: psp_element_type_accounts pea,
7192: psp_default_labor_schedules pdls,
7193: psp_payroll_controls ppc,
7194: psp_payroll_lines ppl,
7195: psp_payroll_sub_lines ppsl,
7196: psp_distribution_lines pdl,
7197: gms_awards_all awd

Line 8468: from psp_payroll_controls ppc,

8464: and business_group_id = p_business_group_id ;
8465:
8466: cursor get_min_max_dist_date is
8467: select min(ptp.start_date), max(ptp.end_date)
8468: from psp_payroll_controls ppc,
8469: per_time_periods ptp
8470: where ppc.source_type = g_source_type
8471: and ppc.payroll_source_code = g_source_code
8472: and (ppc.batch_name = nvl(g_batch_name, ppc.batch_name)

Line 8504: from psp_payroll_controls ppc

8500: l_gen_excess_org_id number; -- 4744285
8501:
8502: cursor get_control_ids is
8503: select payroll_control_id
8504: from psp_payroll_controls ppc
8505: where ppc.source_type = g_source_type
8506: and ppc.payroll_source_code = g_source_code
8507: and (ppc.batch_name = nvl(g_batch_name, ppc.batch_name)
8508: or (ppc.batch_name is null and g_batch_name is null))

Line 8548: update psp_payroll_controls ppc

8544: if get_control_ids%notfound then
8545: close get_control_ids;
8546: exit;
8547: end if;
8548: update psp_payroll_controls ppc
8549: set ppc.cdl_payroll_action_id = pactid
8550: where payroll_control_id = l_payroll_control_id
8551: or parent_payroll_control_id = l_payroll_control_id;
8552: end loop;

Line 8663: psp_payroll_controls ppc

8659:
8660: --- introduced distinct for 4614640
8661: sqlstr := 'select distinct ppl.assignment_id
8662: from psp_payroll_lines ppl,
8663: psp_payroll_controls ppc
8664: where ppc.payroll_control_id = ppl.payroll_control_id
8665: and ppc.cdl_payroll_action_id = :payroll_action_id
8666: order by ppl.assignment_id';
8667:

Line 8762: FROM psp_payroll_controls ppc,

8758:
8759: cursor get_assignments(p_pactid number, stasg number, endasg number,
8760: p_time_period_id number) is
8761: select distinct ppl.assignment_id
8762: FROM psp_payroll_controls ppc,
8763: psp_payroll_lines ppl
8764: WHERE ppc.business_group_id = g_business_group_id
8765: AND ppc.set_of_books_id = g_set_of_books_id
8766: AND ppc.source_type = nvl(g_source_type,ppc.source_type)

Line 8824: FROM psp_payroll_controls

8820: procedure deinit_code(pactid in number) as
8821:
8822: CURSOR payroll_control_cur IS
8823: SELECT payroll_control_id
8824: FROM psp_payroll_controls
8825: WHERE cdl_payroll_action_id = pactid;
8826:
8827: l_total_dist_dr_amount number;
8828: l_total_dist_cr_amount number;

Line 8890: psp_payroll_controls ppc

8886: INTO l_total_dist_dr_amount
8887: FROM psp_distribution_lines pdl,
8888: psp_payroll_sub_lines ppsl,
8889: psp_payroll_lines ppl,
8890: psp_payroll_controls ppc
8891: WHERE ppc.payroll_control_id = payroll_control_rec.payroll_control_id
8892: AND ppc.payroll_control_id = ppl.payroll_control_id
8893: AND ppl.payroll_line_id = ppsl.payroll_line_id
8894: AND ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id

Line 8903: psp_payroll_controls ppc

8899: INTO l_total_dist_cr_amount
8900: FROM psp_distribution_lines pdl,
8901: psp_payroll_sub_lines ppsl,
8902: psp_payroll_lines ppl,
8903: psp_payroll_controls ppc
8904: WHERE ppc.payroll_control_id = payroll_control_rec.payroll_control_id
8905: AND ppc.payroll_control_id = ppl.payroll_control_id
8906: AND ppl.payroll_line_id = ppsl.payroll_line_id
8907: AND ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id

Line 8911: UPDATE psp_payroll_controls

8907: AND ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id
8908: AND pdl.reversal_entry_flag IS NULL
8909: AND ppl.dr_cr_flag = 'C';
8910:
8911: UPDATE psp_payroll_controls
8912: SET dist_dr_amount = l_total_dist_dr_amount,
8913: dist_cr_amount = l_total_dist_cr_amount
8914: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
8915: end loop;