APPS.CN_PAYRUN_PVT dependencies on CN_PERIOD_STATUSES

Line 1210: cn_period_statuses cnps

1206:
1207: CURSOR get_count IS
1208: SELECT COUNT(1)
1209: FROM cn_pay_groups cnpg,
1210: cn_period_statuses cnps
1211: WHERE cnpg.pay_group_id = p_pay_group_id
1212: AND cnpg.period_set_name = cnps.period_set_name
1213: AND cnpg.period_type = cnps.period_type
1214: AND cnps.period_id = p_pay_period_id

Line 1362: CURSOR get_period_range (p_period_id IN cn_period_statuses.period_id%TYPE) IS

1358: FROM cn_payruns
1359: WHERE pay_group_id = p_pay_group_id
1360: ORDER BY payrun_id desc ;
1361:
1362: CURSOR get_period_range (p_period_id IN cn_period_statuses.period_id%TYPE) IS
1363: SELECT start_date, end_date
1364: FROM cn_period_statuses
1365: WHERE period_id = p_period_id
1366: AND org_id=p_org_id;

Line 1364: FROM cn_period_statuses

1360: ORDER BY payrun_id desc ;
1361:
1362: CURSOR get_period_range (p_period_id IN cn_period_statuses.period_id%TYPE) IS
1363: SELECT start_date, end_date
1364: FROM cn_period_statuses
1365: WHERE period_id = p_period_id
1366: AND org_id=p_org_id;
1367:
1368: l_get_period_range_rec get_period_range%ROWTYPE;

Line 1372: l_last_start_date cn_period_statuses.start_date%TYPE;

1368: l_get_period_range_rec get_period_range%ROWTYPE;
1369:
1370:
1371: l_pay_period_id cn_payruns.pay_period_id%TYPE;
1372: l_last_start_date cn_period_statuses.start_date%TYPE;
1373: l_cur_start_date cn_period_statuses.start_date%TYPE;
1374:
1375: BEGIN
1376:

Line 1373: l_cur_start_date cn_period_statuses.start_date%TYPE;

1369:
1370:
1371: l_pay_period_id cn_payruns.pay_period_id%TYPE;
1372: l_last_start_date cn_period_statuses.start_date%TYPE;
1373: l_cur_start_date cn_period_statuses.start_date%TYPE;
1374:
1375: BEGIN
1376:
1377: --