APPS.GLF02220_PKG dependencies on GL_PERIOD_STATUSES

Line 82: GL_PERIOD_STATUSES PS

78: decode(max(BP.rowid), null, 0, 1)
79: FROM
80: GL_BC_PACKET_ARRIVAL_ORDER AO,
81: GL_BC_PACKETS BP,
82: GL_PERIOD_STATUSES PS
83: WHERE
84: PS.application_id = 101
85: AND PS.ledger_id = X_ledger_id
86: AND PS.period_year = X_period_year

Line 729: GL_PERIOD_STATUSES PS

725: NULL)),
726: sum(decode(PS.adjustment_period_flag,'Y',1,0)),
727: max(PS.application_id)
728: FROM
729: GL_PERIOD_STATUSES PS
730: WHERE
731: PS.application_id = 101
732: AND PS.ledger_id = X_ledger_id
733: AND PS.period_year = X_period_year

Line 781: GL_PERIOD_STATUSES PS

777: count(*),
778: nvl(sum(decode(sign(X_start_period_num-period_num),1,1,0)),0)
779: INTO X_num_adj_per_total,X_num_adj_per_before
780: FROM
781: GL_PERIOD_STATUSES PS
782: WHERE
783: PS.application_id = 101
784: AND PS.ledger_id = X_ledger_id
785: AND PS.period_year = X_period_year