APPS.PSP_PREGEN dependencies on PER_TIME_PERIODS

Line 195: FROM per_time_periods ptp

191: AND ROWNUM = 1;
192:
193: CURSOR period_end_date_cur (p_time_period_id NUMBER) IS
194: SELECT end_date
195: FROM per_time_periods ptp
196: WHERE ptp.time_period_id = p_time_period_id;
197:
198: l_currency_count NUMBER;
199: l_period_end_date DATE;

Line 805: per_time_periods T,

801: a.attribute10,
802: a.suspense_auto_glccid,
803: a.suspense_auto_exp_type
804: FROM psp_distribution_interface a,
805: per_time_periods T,
806: psp_organization_accounts susp --- introduced for 5164744
807: WHERE batch_name = p_batch_name and
808: T.time_period_id = a.time_period_id and
809: susp.organization_account_id(+) = a.suspense_org_account_id;

Line 1267: FROM Per_Time_Periods

1263: X_return_status OUT NOCOPY varchar2,
1264: X_return_code OUT NOCOPY varchar2) IS
1265: CURSOR check_period_csr IS
1266: SELECT Time_Period_id
1267: FROM Per_Time_Periods
1268: WHERE Payroll_id = x_Payroll_ID
1269: and Time_Period_ID = x_Payroll_Period_ID
1270: and (x_Effective_Date between start_date and end_date);
1271:

Line 1355: per_time_periods c

1351: X_return_code OUT NOCOPY varchar2) IS
1352: CURSOR check_element_csr IS
1353: SELECT a.element_type_id
1354: FROM psp_element_types a,
1355: per_time_periods c
1356: WHERE a.element_type_id = x_Element_Type_ID and
1357: c.time_period_id = x_payroll_period_id
1358: -- and ((c.start_date between a.start_date_active and a.end_date_active)
1359: -- or (c.end_date between a.start_date_active and a.end_date_active)

Line 1695: FROM per_time_periods

1691:
1692: begin
1693: SELECT start_date,end_date
1694: into l_payroll_begin_date,l_payroll_end_date
1695: FROM per_time_periods
1696: WHERE time_period_id = x_time_period_id;
1697:
1698: if NVL(x_gl_ccid,0) = 0 and NVL(x_project_id,0) = 0 then
1699: return x_distribution_date;