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 808: per_time_periods T,

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

Line 1270: FROM Per_Time_Periods

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

Line 1358: per_time_periods c

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

Line 1698: FROM per_time_periods

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