APPS.CN_API dependencies on CN_PERIOD_STATUSES

Line 123: FROM cn_period_statuses_all

119:
120: BEGIN
121: SELECT period_name
122: INTO l_period_name
123: FROM cn_period_statuses_all
124: WHERE period_id = p_period_id
125: AND org_id = p_org_id
126: AND period_status IN ('F', 'O');
127:

Line 146: FROM cn_period_statuses_all

142:
143: BEGIN
144: SELECT period_id
145: INTO l_period_id
146: FROM cn_period_statuses_all
147: WHERE Upper(period_name) = Upper(p_period_name)
148: AND org_id = p_org_id
149: AND period_status IN ('F', 'O');
150:

Line 1501: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c

1497: BEGIN
1498:
1499: SELECT a.period_id
1500: INTO l_pay_period_id
1501: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c
1502: WHERE a.period_set_id = c.period_set_id
1503: AND a.org_id = p_org_id
1504: AND a.period_type_id = c.period_type_id
1505: AND b.pay_group_id = c.pay_group_id

Line 3069: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps

3065: BEGIN
3066: -- isPayee if assigned to srp in this period
3067: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3068: (SELECT 1
3069: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps
3070: WHERE cnspay.payee_id = p_salesrep_id
3071: AND cnps.period_id = p_period_id
3072: AND cnps.org_id = p_org_id
3073: AND cnspay.org_id = p_org_id

Line 3086: (SELECT 1 FROM cn_srp_roles sr, cn_period_statuses cnps

3082: l_exist := 0;
3083: BEGIN
3084: -- isPayee if have Payee role in this period
3085: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3086: (SELECT 1 FROM cn_srp_roles sr, cn_period_statuses cnps
3087: WHERE sr.salesrep_id = p_salesrep_id
3088: AND sr.role_id = 54
3089: AND sr.org_id = p_org_id
3090: AND cnps.org_id = p_org_id

Line 3350: cn_period_statuses pr,

3346: (SELECT DISTINCT m1.resource_id,
3347: greatest(pr.start_date, m1.start_date_active) start_date,
3348: least(pr.end_date, nvl(m1.end_date_active, pr.end_date)) end_date
3349: FROM jtf_rs_resource_extns re1,
3350: cn_period_statuses pr,
3351: jtf_rs_group_usages u1,
3352: jtf_rs_rep_managers m1
3353: WHERE re1.user_id = l_user_id --129941
3354: AND (pr.period_id, pr.org_id) =

Line 3419: cn_period_statuses pr,

3415: (SELECT DISTINCT m1.resource_id,
3416: greatest(pr.start_date, m1.start_date_active) start_date,
3417: least(pr.end_date, nvl(m1.end_date_active, pr.end_date)) end_date
3418: FROM jtf_rs_resource_extns re1,
3419: cn_period_statuses pr,
3420: jtf_rs_group_usages u1,
3421: jtf_rs_rep_managers m1
3422: WHERE re1.user_id = l_user_id --129941
3423: AND (pr.period_id, pr.org_id) =