APPS.PSP_LABOR_DIST dependencies on PER_TIME_PERIODS

Line 66: /* Bug 2663344 reverted change done for 1874696,re-introduced per_time_periods */

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 */
67: CURSOR payroll_cur(P_PAYROLL_CONTROL_ID IN NUMBER) IS
68: SELECT ptp.end_date, --- added for 2663344
69: ppl.payroll_line_id,
70: ppl.assignment_id,

Line 101: per_time_periods ptp,

97: or_expenditure_org_id,
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

Line 6943: from per_time_periods

6939:
6940: cursor get_period_dates(p_time_period_id integer) is
6941: select start_date,
6942: end_date
6943: from per_time_periods
6944: where time_period_id = p_time_period_id;
6945:
6946: cursor org_excess_act(p_asg_id integer,
6947: p_dist_date date,

Line 8410: from per_time_periods

8406:
8407: if g_time_period_id is not null and g_payroll_id is null then
8408: select payroll_id
8409: into g_payroll_id
8410: from per_time_periods
8411: where time_period_id = g_time_period_id;
8412: end if;
8413:
8414: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

Line 8469: per_time_periods ptp

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)
8473: or (ppc.batch_name is null and g_batch_name is null))

Line 8793: from per_time_periods

8789: if g_time_period_id is not null and g_payroll_id is null then
8790: --#fnd_file.put_line(fnd_file.log,'########AssignCode2#######');
8791: select payroll_id
8792: into g_payroll_id
8793: from per_time_periods
8794: where time_period_id = g_time_period_id;
8795: end if;
8796: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8797: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');