APPS.CN_API dependencies on CN_PERIOD_STATUSES

Line 101: FROM cn_period_statuses_all

97:
98: BEGIN
99: SELECT period_name
100: INTO l_period_name
101: FROM cn_period_statuses_all
102: WHERE period_id = p_period_id
103: AND org_id = p_org_id
104: AND period_status IN ('F', 'O');
105:

Line 124: FROM cn_period_statuses_all

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

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

1475: BEGIN
1476:
1477: SELECT a.period_id
1478: INTO l_pay_period_id
1479: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c
1480: WHERE a.period_set_id = c.period_set_id
1481: AND a.org_id = p_org_id
1482: AND a.period_type_id = c.period_type_id
1483: AND b.pay_group_id = c.pay_group_id

Line 3047: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps

3043: BEGIN
3044: -- isPayee if assigned to srp in this period
3045: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3046: (SELECT 1
3047: FROM cn_srp_payee_assigns cnspay, cn_period_statuses cnps
3048: WHERE cnspay.payee_id = p_salesrep_id
3049: AND cnps.period_id = p_period_id
3050: AND cnps.org_id = p_org_id
3051: AND cnspay.org_id = p_org_id

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

3060: l_exist := 0;
3061: BEGIN
3062: -- isPayee if have Payee role in this period
3063: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3064: (SELECT 1 FROM cn_srp_roles sr, cn_period_statuses cnps
3065: WHERE sr.salesrep_id = p_salesrep_id
3066: AND sr.role_id = 54
3067: AND sr.org_id = p_org_id
3068: AND cnps.org_id = p_org_id